Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 173
  • Last Modified:

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:

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
0
Lee Ingalls
Asked:
Lee Ingalls
1 Solution
 
NBVCCommented:
That's supposed to be:

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...
0
 
Lee IngallsDirector of IT/TS, Quality and FinanceAuthor Commented:
Thanks NBVC!
I looked at it 10 times and missed the obvious.
0
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

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now