referencing a blank cell

[Guest]

I'm trying to write a logic statement that says "if this field is blank, then "error". How do I reference the "blank" field in the formula?

 

[gigglefritz]

Try

=IF(ISBLANK(A1),"error","")

-----Original Message-----
I'm trying to write a logic statement that says "if this

field is blank, then "error". How do I reference
the "blank" field in the formula?

 

[Frank Kabel]

Hi
something like
=IF(ISBLANK(A1),"ERROR","No Error")

 

[Guest]

What if it's the opposite situation where if the cell is not blank, make the cell red? I Tried using ISTEXT in the CF formula but it said I'm not allowed to use those in a CF situation.

Thanks,
Frank

Give it a conditional format with the conditions set as (from first drop
down list) "Cell Value Is" (from second drop down list) "Equal to" and in
the blank white space type "0". Then select your format and format it how
you wish it to look if the cell value is blank. HTH

 

[Frank Kabel]

Hi
=A1<>""