![Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.](https://cxcs.microsoft.net/static/public/surface-and-devices/neutral/4873755a-8b1e-497e-bc54-101d1e75d3e7/d07c07fd6aabfe12ed716e87301dc3a1a3a7b5b0.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.