Conditional Formatting

[Aaron]

Hello,

I'm trying to create a conditional format that highlights
cells that are blank. The problem I'm running into is
the fact that my data contains zeros as inputs and the
conditional formatting keeps highlighting the zeros too.
I need the conditional format to only highlights cells
that are completely blank. Thanks for any help.

Aaron

 

[Mike Lewis]

Try setting the validation formula to:

=CELL("type",a1)="b"

It will differentiate between blanks and zeros

Mike