![Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.](https://support.content.office.net/en-us/media/4873755a-8b1e-497e-bc54-101d1e75d3e7.png)
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.