ExcelBanter - Conditinal formatting blank output cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditinal formatting blank output cell (https://www.excelbanter.com/excel-worksheet-functions/445817-conditinal-formatting-blank-output-cell.html)

Nicholsonz

Conditinal formatting blank output cell

1 Attachment(s)

Hi guys,

I was wondering ,
how do you add in another further conditioning on this condition for a 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 thanks

Vacuum Sealed

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.

All times are GMT +1. The time now is 06:14 AM.