Conditional Formatting

D

Daniel

Hello,

I would like to apply a conditional formatting to certain cells and make the
change colors if their values differs from "functional". However, I don't
want this rule to apply to cells that have nothing entered in them yet.

I use the Cell Value Is not equal to ="Functional" with the appropriate
settings to format the text. My problem is that null cells get formatted as
well. How can I get around this. Only color those cells that have non null
value that are not eual to "functional"??

Thanks,

Daniel
 
D

Domenic

Try the following...

1) Select your range of cells
2) Format > Conditional Formatting > Formula Is
3) Enter the following formula:
=(A1<>"")*(A1<>"functional")
4) Choose your formatting
5) Click Ok

Hope this helps!
 
Top