View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default 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