How do I check for an empty cell in a formula?

[sasquatchbill]

Hello!

I'm trying to create conditional formatting based on if a certain cell
is empty or not. Specifically, I'm looking to see if my row has a date
entered in column E or if it's blank.

How do I check that in my CF formula?

 

[daddylonglegs]

You can use

=A1<>""

or because a date is a number to excel

=ISNUMBER(A1)

 

[Wiley]

Try =IF(ISBLANK(A1)),...followed by the resto of your formula. Let us know
if you need more help.

 

[CLR]

Formula is: =E1=0

or

Formula is: =E1<>0

Vaya con Dios,
Chuck, CABGx3

 

[sasquatchbill]

Got it to work using the $E1 = 0 suggestion.
Thanks guys!!!
Much appreciated!