Conditinal formatting blank output cell

[Nicholsonz]

Hi guys,

I was wondering ,
how do you add in another further conditioning on this condition for
blank cell when there is nothing/blank on the input cell??

=IF(TODAY()<D6, "VALID",IF(TODAY()=D6,"DUE","EXPIRED"))

PLs see attached for more info on what i mean.

Hope someone could help me thank

+-------------------------------------------------------------------
|Filename: 1.png
|Download: http://www.excelbanter.com/attachment.php?attachmentid=331
+-------------------------------------------------------------------

 

[Vacuum Sealed]

=IF(TODAY()<D6, "VALID",IF(TODAY()=D6,"DUE","EXPIRED"))

Try this

=IF(D6="","",IF(TODAY()<D6, "VALID",IF(TODAY()=D6,"DUE","EXPIRED")))

HTH
Mick.