Chapter 23. Visually Analyzing Data

Highlight Cells That Are Greater Than a Specified Value

You can use conditional formatting to highlight cells in a range that are greater than a value you specify. When you use conditional formatting, you set criteria for information in a range and Excel identifies the cells in the range that meet the criteria. You can also highlight values that are less than a value you specify or equal to a value you specify. For example, if your worksheet contains test scores, then you can highlight all the scores that are higher than a value you specify.

When you highlight cells that are greater than, less than, or equal to a value you specify, Excel compares the contents of the cells in the range you identify to a value you ...

Get Master VISUALLY® Excel® 2010 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.