Conditional formatting enables you to highlight cells with a curtain color, depending on the cell’s value.
For example, highlighting positive values with green background color, and negative values with red.
(actually not only the color can be set, but every aspect of cell formatting can be applied this way - font style, size, bold, underline etc.)
The conditional formatting “sticks” to the cell, and changes dynamically depending on the cell’s value. In the above example, if a cell had a positive value (hence was formatted with green) and then it changed its value to negative, it will automatically become red.
More examples for conditional formatting:
- Highlight all values greater than $2000.
- Highlight only the cell containing the highest value among a group of cells. (this could be relevant when you wish to highlight the highest score in the class, or highlight the highest salary in a company)
- Highlight all duplicate values in a curtain range (don’t you wish to easily find and locate annoying duplicate values in a list?)
|