Conditional Formatting based on expiration dates [Solved/Closed]

 BC -

I am trying to figure out how to introduce conditional formatting to a range of cells with date values. I want each cell in the range to be highlighted based on whether it is "expired" or not - that is, if the date is older than TODAY().

I've tried


to highlight a cell in the F column if the date is older than TODAY(), but this didn't seem to work. I'm trying to avoid having to do this to cells individually. Any assistance would be greatly appreciated.

Thank you.

Very respectfully,


2 replies

Registration date
Tuesday March 3, 2015
Last seen
July 3, 2015
just some basic menu usage

please note that you need to set the cells format to Date.

Damn it !!!, is it ever gonna be the way I want it to be?
I didn't know I could do it that way. Thank you very much for your help.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!