More than 3 conditions in conditional formatting

  • Thread starter Thread starter Kelli
  • Start date Start date
K

Kelli

I'm trying to use conditional formatting for a certain
column, but as soon as I put in 3 conditions, the add
button grays out

I want:
= 0 to be black
Click to expand...
0>x>=-7 to be red
-7>x>=-21 to be yellow
<-21 to be green

Any ideas??
Thanks
 
Make cell start black by default
First conditions is formula
=AND(A1<0,A1>=-7) and your color red
Second condition is formula
=AND(A1<-7,A1>=-21) and your color yellow
Third condition is formula
=A1<-21 and your color green.

A1 is of course the cell to be verified. Use format brush to copy this
format to all cells in the column.

rob
 
3 conditions is the max for conditional formatting.
If you use coloured fonts you can use the regular formatting as well
and of course if you only have 4 conditions you can leave >=0 since that
would be default
 
Hi

3 is the maximum. But you forget that "no condition met" is the fourth state. So fomat for
=0 as default and forget about posotive numbers. The three conditions should then cover
Click to expand...
for >=-7, >=-21 and finally <-21.
 
kelli,

treat the final three as your three conditions.... if the value does
not meet any of these three (e.g. is greater than or equal to zero...)
it will apply the original format of the cell - black, or whatever you
set as the default, non-conditional format of the cell

Sean
 
Back
Top