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

Chapter 2. Format Annoyances > CONDITIONAL FORMATTING ANNOYANCES

CONDITIONAL FORMATTING ANNOYANCES

CHANGE CELL FORMATTING BASED ON THE CELL'S VALUE

The Annoyance:

I'm a commercial gardener and I use Excel to track the temperature in my greenhouses. I want to automatically flag any hours during which the temperature is less than 75 degrees by displaying that cell's value in red text. How do I do it?

The Fix:

Conditional formatting is one of Excel's handiest features. To change a cell's formatting based on its contents, follow these steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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