
Try it!
Conditional Formatting adds visual cues, like different colors, that help you spot highs and lows or other trends.
-
Select the cells or data range you want to format.
-
Select Conditional Formatting.
-
Choose one of the preset types:
-
Highlight Cell Rules
-
Top/Bottom Rules
-
Data Bars
-
Color Scales
-
Icon Sets
-
-
Choose a criteria.
-
Set the conditions and select OK.