• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Advanced Formatting and Editi... > Applying Conditional Formats

Applying Conditional Formats

Choosing Format, Conditional Formatting offers an easy way to apply formats that stay “asleep” until the values in the formatted cells achieve a specified state. We call this trapping a value. Sometimes tables with this sort of conditional formatting are referred to as stoplight tables, because they are often used to call attention to potential problem areas in a business model.

For example, you could apply conditional formatting to a range of cells that contain sales totals, specifying that if any of the totals drops below $10,000, the format of the cell changes to stand out from the other cells. To apply conditional formatting to cells, follow these steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint