how to add additional condition?

[yakou]

Hi all,

I would like to make the cell with four conditions. Excel
only provides three conditons. How do I add another
condition?

Say, I would like to have:

If cell >= 88.1, cell becomes blue
If cell is greater than 85.7 or smaller than 88.1, cell
becomes yellow.
If cell is between 83.8 and 85.7, turn the cell to pink
If cell is between 20 and 83.8, turn the cell to red.

Please help. Thank you in advance!!!!

yakou

 

[Mike]

3 conditional formats plus the default = 4 possible
formats. So set the default format to blue, then use the
3 conditional formats for the 3 between x and y
conditions. You can't have any more conditions using
conditional formating. If you need more, then you'll have
to write a macro.