Conditional Formatting - Dates [Solved]

BethanMary4 2 Posts Monday February 5, 2018Registration date February 6, 2018 Last seen - Feb 5, 2018 at 11:47 AM - Latest reply: BethanMary4 2 Posts Monday February 5, 2018Registration date February 6, 2018 Last seen
- 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 

Your reply

4 replies

Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen - Feb 5, 2018 at 12:21 PM
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..."
Respond to Mazzaropi
Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen - Feb 6, 2018 at 05:21 AM
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
Respond to Mazzaropi
BethanMary4 2 Posts Monday February 5, 2018Registration date February 6, 2018 Last seen - Feb 6, 2018 at 09:04 AM
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
Respond to BethanMary4