O'Reilly logo

Microsoft® Office® Professional 2013 Plain & Simple by Katherine Murray

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

Using conditional formatting to showcase data trends

Conditional formatting makes it easy for you to see how your data is shaping up in different ways. You can display values as data bars of different colors, using a color scale to display differences in data. Additionally, you can display icons in the cells (such as an up arrow or down arrow), add greater-than or less-than symbols, highlight the top or bottom percent of values shown, or clear the formatting altogether. Conditional formatting is fun to apply and easy to use, and it can help those who are unfamiliar with your worksheet see easily what your data shows.

Highlight data results

  1. Open an Excel workbook and drag to select the values that you want to format.

  2. Click the Home tab. ...

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