Conditional Formatting with Dates

Closed

Lylibean - Apr 7, 2015 at 03:13 PM
MaxStart Posts 339 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?

Conditional Formatting with Dates
How to clear formatting in excel - Guide
Excel conditional formatting if another cell contains specific text - Excel Forum
Excel formula to change cell color without conditional formatting - Excel Forum
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
Phone formatting software for pc - Download - File management

1 response

Answer 1 / 1

MaxStart Posts 339 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 69
Apr 7, 2015 at 03:55 PM

check this, Conditional Formatting based on expiration dates

dreaming is just a waste of time.

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Highlight cell if another cell contains any text

Conditional formating - apply on more cells

one cell will turn green when the two other cells match

Similar discussions

Subscribe To Our Newsletter!