Thread
:
conditional formatting with blank date fields
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
conditional formatting with blank date fields
=AND(D40<"",E40="")
Works for me.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Freida" wrote in message
...
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?
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann