Thread: Conditinal formatting blank output cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vacuum Sealed Vacuum Sealed is offline
external usenet poster
  
Posts: 259
Default Conditinal formatting blank output cell
On 19/04/2012 11:50 AM, Nicholsonz wrote:
=IF(TODAY()<D6, "VALID",IF(TODAY()=D6,"DUE","EXPIRED"))


Try this

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

HTH
Mick.
Reply With QuoteReply With Quote