| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditinal formatting blank output cell
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditinal Formatting | New Users to Excel | |||
| Conditinal Formatting | Excel Discussion (Misc queries) | |||
| Conditinal Formatting | Excel Programming | |||
| Conditinal formatting - AND function | Excel Worksheet Functions | |||
| Font size in conditinal formatting | Excel Discussion (Misc queries) | |||
Linear Mode
