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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
