O'Reilly logo

Master VISUALLY® Excel® 2010 by Elaine Marmel

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

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