O'Reilly logo

Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables, 4th Edition by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required