Conditional formatting
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.