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?


--
sasquatchbill
------------------------------------------------------------------------
sasquatchbill's Profile: http://www.excelforum.com/member.php...o&userid=36550
View this thread: http://www.excelforum.com/showthread...hreadid=569079

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

You can use

=A1<""

or because a date is a number to excel

=ISNUMBER(A1)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=569079

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

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

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

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

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

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


--
sasquatchbill
------------------------------------------------------------------------
sasquatchbill's Profile: http://www.excelforum.com/member.php...o&userid=36550
View this thread: http://www.excelforum.com/showthread...hreadid=569079