What is Conditional Formatting?


show more What is Conditional Formatting? provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

What is Conditional Formatting?

We're now going to take a look at something that's very powerful in Excel 2007, and that's Conditional Formatting. For those of you that would like to follow along, please open EatCake Sales Forecast5, found in your Exercise Files. What does Conditional Formatting do? Let's take a look at the description that we find on the ribbon. As we mouse over the Conditional Formatting option, on the Home tab of the ribbon, it explains to us that conditional formatting will highlight interesting cells, emphasize unusual values, and using visual data such as data bars, color scales and icon sets, identify specific areas that you'd like to highlight in your table.

Let's see how this works in practice. First of all, select an area of the table that you would like to highlight. So by clicking on cell E4, and dragging until I reach cell E10, I've identified that that's the particular of the table that I want to work with. I go up to the Conditional Formatting section and cli...

What is Conditional Formatting?
Video duration: 2m 20s 5h 13m Beginner

Viewers:

What is Conditional Formatting? provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...