The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
Conditional Formatting is ignoring some date conditions.
MS Excel 2010 Conditional Formatting Rules Manager, I have 5 rules that check for the following date conditions:
There are two conditions that are no longer formatting... "<Today()" and Today.
These had been working until I HIDE columns K & L. I've tried unhiding and re-applying the conditional formatting but it is still not formatting.
See attached screenshot.
Conditional-Formatting.pdf
Cell contains a blank value - No Format Set
Cell Value = "<Today()"
Today
Next Week
This Week
There are two conditions that are no longer formatting... "<Today()" and Today.
These had been working until I HIDE columns K & L. I've tried unhiding and re-applying the conditional formatting but it is still not formatting.
See attached screenshot.
Conditional-Formatting.pdf
Asked:
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
Cell Value >> Is Less Than >> =TODAY()
in 3 separate fields... and not quotes...
That might ending up fixing the TODAY condition too... as that looks like it should be right...