Chapter 25. 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 of 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 ...
Get Master Visually®: Excel® 2007 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.
