| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| Dropping the cell in the empty cell by formula | Excel Discussion (Misc queries) | |||
| How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
| Is there a way to go to next empty cell in a formula | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
