Conditional formating
The only way to get a fourth is to set the cells to that colour as default,
and any that match the CF conditions will assume one of the other three.
--
HTH
-------
Bob Phillips
"PCOR" wrote in message
gers.com...
Currnetly you can conditional format at cell for up to 3 conditions
Example under 40=red, 41 to 100 = blue and over 101= orange
Is there a way to add a fouth condition? Say under 39 = green
Thanks
--
Norton Professional 2004 says this email is clean...believe it
|