Conditional formatting in case of no date returned

[surya9]

Hi
I have a Vlookup formula in Cell A1 which returns a date.
I am working on conditional formatting. I am done with everything but, when the cell doesnot return any date.. I mean if the cell A1 is blank it must be displayed as red in E1.
If i use Isblank in Condtional formatting it does not work, because eventhough the cell A1 is visible blank, since it has a formula it is ideally not blank. can you please suggest how to get color Red in E1 is A1 doesnot return a date.

[DonkeyOte]

Use COUNTBLANK which treats Null as Blank (unlike ISBLANK, COUNTA etc...)

So Conditional Format rule of:

=COUNTBLANK(A1)
set to red

it follows given values are otherwise numeric (we assume) you could also use either of: =A1="" ... or =ISTEXT(A1)

[martindwilson]

i take the formula returns ""
as in
=IF(B1=1,TODAY(),"")
then use
=A1=""

[surya9]

Hi
Thank you Countblank has helped me...