Conditional Formatting - Dates [Solved/Closed]

Report
Posts
2
Registration date
Monday February 5, 2018
Status
Member
Last seen
February 6, 2018
-
Posts
2
Registration date
Monday February 5, 2018
Status
Member
Last seen
February 6, 2018
-
Hello,

On a spreadsheet, the cells in column N contain a date.

I need any date that is 6 weeks ago or longer to be highlighted.

How do I do this?

3 replies

Posts
1875
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 9, 2021
139
BethanMary4, Good afternoon.

Try to use:

Select N1:N100 (as your necessity)

Conditional Format --> Using formula -->
=AND(TODAY()-N1<=42;N1-TODAY()<=42)

--> Format: Fill color as desire
OK

Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Unfortunately not. I just get an error message saying "we found a problem with this formula..."
Posts
1875
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 9, 2021
139
BethanMary4, Good morning.

Maybe this is about of separator sign of your system:

Try to use COMMA ( , ) instead of SEMICOLON ( ; )

Old --> =AND(TODAY()-N1<=42 ; N1-TODAY()<=42)

New --> =AND(TODAY()-N1<=42 , N1-TODAY()<=42)

Please, tell us if it's working now.
I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Posts
2
Registration date
Monday February 5, 2018
Status
Member
Last seen
February 6, 2018

It's ok, I figured it out.

I've done
"format only cells that contain"
cell value less than or equal to TODAY()-42

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!