Conditional formatting
![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 provides visual cues to help you quickly make sense of your data.
Note: The instructions below match the video, which shows only one of the many ways to use conditional formatting. To learn more, see Use conditional formatting to highlight information.
-
Select the cells.
-
Select Home > Conditional Formatting > Top/Bottom Rules > Top 10 Items.
-
Choose how many values you want highlighted.
-
Select a format.
-
Select OK.