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

Chapter 3. Analyzing Data with Microsoft... > Applying Conditional Formatting

Applying Conditional Formatting

Formatting involves changing the size, font, color, bolding, underlining, and other characteristics of text. Conditional formatting involves changing text properties if specific conditions are met.

To understand conditional formatting, imagine an electronic digital kitchen timer. When the time reaches zero, usually an audible beep sounds, a bell rings, the number flashes, or something similar occurs. You can apply this same kind of behavior to the formats of one or more worksheet cells. If a cell value were less than the number 100, for instance, you could display the value in red. Similarly, if a cell value were greater than 1000, you could change the cell’s background color to green.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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