| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting with blank date fields
I am trying to do a CF on a cell as follows:
If D40 is not blank and E40 is blank, I would like to apply the CF. D40 and E40 are both formatted as dates. I tried =AND(D40<"",E40=""), but it did not work. I also tried comparing it to 0 (zero) rather than to "", but it still didn't work. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting:highlight row based on blank or non-blank c | Excel Worksheet Functions | |||
| F2 shortcut and strange formatting of date fields | Excel Discussion (Misc queries) | |||
| Conditional formatting - Blank | Excel Discussion (Misc queries) | |||
| conditional formatting:highlight row based on blank or non-blank c | Excel Discussion (Misc queries) | |||
| Formatting date fields after export | Excel Discussion (Misc queries) | |||
Threaded Mode
