Conditional Formatting - Dates [Solved/Closed]

Report
Posts
2
Registration date
Monday February 5, 2018
Status
Member
Last seen
February 6, 2018
-
BethanMary4
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
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
134
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
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
134
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