Conditional Formatting with Dates
Closed
Lylibean
-
Apr 7, 2015 at 03:13 PM
MaxStart Posts 338 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 - Apr 7, 2015 at 03:55 PM
MaxStart Posts 338 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 - Apr 7, 2015 at 03:55 PM
I am trying to fill cells in a column which contain a date that has already passed. I go to 'Conditional Formatting', choose 'Manage Rules' and click 'New Rule'. I ask to input a formula, which is:
=$F<TODAY()
I choose my cell fill and hit okay, then am told by Excel, "When you use an = Excel thinks you are entering a formula."
I have seen this formula on numerous sites regarding conditional formatting and dates, and have copied and pasted the text from those websites into the formula bar, only to be told that it is not a valid formula. Am I losing my mind?
=$F<TODAY()
I choose my cell fill and hit okay, then am told by Excel, "When you use an = Excel thinks you are entering a formula."
I have seen this formula on numerous sites regarding conditional formatting and dates, and have copied and pasted the text from those websites into the formula bar, only to be told that it is not a valid formula. Am I losing my mind?
Related:
- Conditional Formatting with Dates
- Different dates of "end to end encryption message" on blank chat? ✓ - Network Forum
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Using nested if to blank out adjacent cells - Excel Forum
- How to format windows 7 with keyboard - Guide
1 response
MaxStart
Posts
338
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
69
Apr 7, 2015 at 03:55 PM
Apr 7, 2015 at 03:55 PM
check this, Conditional Formatting based on expiration dates

dreaming is just a waste of time.

dreaming is just a waste of time.