Previous Topic Next Topic

Conditional Formatting based on expiration dates

Solved/Closed
bc - Apr 6, 2015 at 02:57 PM
 BC - Apr 6, 2015 at 03:46 PM
Hello,

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

=($F$3:$F74)<TODAY()

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,

BC

2 responses

Answer 1 / 2
MaxStart Posts 339 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 69
Apr 6, 2015 at 03:24 PM
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?
0
Answer 2 / 2
BC
Apr 6, 2015 at 03:46 PM
I didn't know I could do it that way. Thank you very much for your help.
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses