Conditional Formatting - Dates [Solved/Closed]

Posts
2
Registration date
Monday February 5, 2018
Status
Member
Last seen
February 6, 2018
- - Latest reply: BethanMary4
Posts
2
Registration date
Monday February 5, 2018
Status
Member
Last seen
February 6, 2018
- Feb 6, 2018 at 09:04 AM
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?
See more 

3 replies

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
130
0
Thank you
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
130
0
Thank you
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
0
Thank you
It's ok, I figured it out.

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