FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values.

Detailed explanation-2: -If you want to highlight cells that are not blank, you can use the Conditional Formatting feature. To use this feature, go to the Home tab and click Conditional Formatting in the Styles group. Then click Highlight Cell Rules and click Not Blanks. Excel will highlight all of the cells that are not blank.

Detailed explanation-3: -On the Home tab, under Format, click Conditional Formatting. Point to Color Scales, and then click the color scale format that you want. The top color represents larger values, the center color, if any, represents middle values, and the bottom color represents smaller values.

Detailed explanation-4: -Conditional formatting allows users to automatically apply formattings such as colours, icons, and data bars to one or more cells based on the cell value. To do Conditional formatting, users need to create a conditional formatting rule.