Excel: Conditional formatting: Considering the fourth option
Monday, December 24th, 2007This article was adapted from MrExcel.com. Visit the MrExcel.com Web site for more tips and information.
Conditional formatting in Excel allows for three conditions. However, by setting up conditions correctly — from least to most restrictive — you can really allow for four conditions, when the default formatting of the cell is considered. For example, say you want to add color to your data like so:
| If cell value is | Fill with |
|---|---|
| Less than or equal to -25 | Red |
| Between 0 and -25 | Yellow |
| Between 0 and 25 | Green |
| Over 25 | Black |
Popularity: 9% [?]
