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

Chapter 25. Advanced Worksheet Formattin... > Using Conditional Formatting to Iden...

Using Conditional Formatting to Identify Key Values

Conditional formatting lets you set font attributes, colors, and other formatting options that cause data to appear differently based on the value displayed in a cell. Most often, you'll use this feature to set an alarm that highlights data that is outside of an expected range. For example, you might attach conditional formatting to a row of totals on a daily sales report, displaying each cell's contents in bold red letters if it falls below a target level and in bright green if the number is significantly above average. In an employee roster, you might use bold formatting to identify the names of employees who are overdue for a formal evaluation.

TIP FROM

Conditional formats are most effective when used sparingly. If every cell in a worksheet has “special” formatting, nothing stands out. The best use of this option is to highlight truly unusual conditions that require action—when you open a worksheet and see one or two items in bright red, they get your full attention.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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