Chapter 8
Learning Data Analysis Techniques
Highlight Cells That Meet Some Criteria
A conditional format is formatting that Excel applies only to cells that meet the criteria you specify. For example, you can tell Excel to apply only the formatting if a cell’s value is greater than or less than some specified amount, between two specified values, or equal to some value. You can also look for cells that contain specified text, dates that occur during a specified timeframe, and more.
When you set up your conditional format, you can specify the font, border, and background pattern. This helps to ensure that the cells that meet your criteria stand out from the other cells in the range.
Highlight Cells That Meet Some Criteria
Select the range ...
