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

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?

You can use

=A1<>""

or because a date is a number to excel

=ISNUMBER(A1)

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

"sasquatchbill" wrote:

>
> 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?
>
>
> --
> sasquatchbill
> ------------------------------------------------------------------------
> sasquatchbill's Profile: http://www.excelforum.com/member.php...o&userid=36550
> View this thread: http://www.excelforum.com/showthread...hreadid=569079
>
>

Formula is: =E1=0

or

Formula is: =E1<>0

Vaya con Dios,
Chuck, CABGx3



"sasquatchbill" wrote:

>
> 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?
>
>
> --
> sasquatchbill
> ------------------------------------------------------------------------
> sasquatchbill's Profile: http://www.excelforum.com/member.php...o&userid=36550
> View this thread: http://www.excelforum.com/showthread...hreadid=569079
>
>

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