Assuming your first cell to evaluate is in A2:
In your conditional formatting, select Formula Is, then

=ABS(TODAY()-A2)<90

"michelle" wrote:

I'm trying to figure out how to make conditional formatting highlight any
dates in a spreadsheet when they are within 90 days or less. I've looked
forever in the help files, etc but can't find what i'm looking for. HELP?

Sean, I tried using your formula but with the -A2 value as -D2:D55 because
the column that has the dates that I want to use the formula on are D2
through D55. so my formula looked like this
Formula is =ABS(TODAY()-D2:D55)<90

It didn't work. how do I get the formula to work for D2 through D55?

BTW -- thank you for your help! I really appreciate it

"Sean Timmons" wrote:

Assuming your first cell to evaluate is in A2:
In your conditional formatting, select Formula Is, then

=ABS(TODAY()-A2)<90

"michelle" wrote:

I'm trying to figure out how to make conditional formatting highlight any
dates in a spreadsheet when they are within 90 days or less. I've looked
forever in the help files, etc but can't find what i'm looking for. HELP?

So, you're going to want to check formatting in cells D2 through D55..

In D2, in conditional formatting, type

=ABS(TODAY()-D2)<90

Then copy and paste special/formats down to D55. This will automatically
update your conditional format to check D3, D4, etc. against TODAY()

"michelle" wrote:

Sean, I tried using your formula but with the -A2 value as -D2:D55 because
the column that has the dates that I want to use the formula on are D2
through D55. so my formula looked like this
Formula is =ABS(TODAY()-D2:D55)<90

It didn't work. how do I get the formula to work for D2 through D55?

BTW -- thank you for your help! I really appreciate it

"Sean Timmons" wrote:

Assuming your first cell to evaluate is in A2:
In your conditional formatting, select Formula Is, then

=ABS(TODAY()-A2)<90

"michelle" wrote:

I'm trying to figure out how to make conditional formatting highlight any
dates in a spreadsheet when they are within 90 days or less. I've looked
forever in the help files, etc but can't find what i'm looking for. HELP?

I think I figured it out. I highlighted D2 through D55 and I made the formula
=ABS(TODAY()-D2)<90
then it worked for all of those cells. WOOHOO! finally-after an entire day
working on this and going through tutorials etc.

Do you know where I can go to learn how to make these formula's so I know
what why I just typed those things into the formula?

"Sean Timmons" wrote:

Assuming your first cell to evaluate is in A2:
In your conditional formatting, select Formula Is, then

=ABS(TODAY()-A2)<90

"michelle" wrote:

I'm trying to figure out how to make conditional formatting highlight any
dates in a spreadsheet when they are within 90 days or less. I've looked
forever in the help files, etc but can't find what i'm looking for. HELP?

Hi,

If what you are looking for is dates within 90 days or less on either side
of today then the previous suggests each provide part of the solution:

=ABS(TODAY()-A2)<90
=(TODAY()-A2)<=90

instead use
=ABS(TODAY()-A2)<=90

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"michelle" wrote:

I think I figured it out. I highlighted D2 through D55 and I made the formula
=ABS(TODAY()-D2)<90
then it worked for all of those cells. WOOHOO! finally-after an entire day
working on this and going through tutorials etc.

Do you know where I can go to learn how to make these formula's so I know
what why I just typed those things into the formula?

"Sean Timmons" wrote:

Assuming your first cell to evaluate is in A2:
In your conditional formatting, select Formula Is, then

=ABS(TODAY()-A2)<90

"michelle" wrote:

I'm trying to figure out how to make conditional formatting highlight any
dates in a spreadsheet when they are within 90 days or less. I've looked
forever in the help files, etc but can't find what i'm looking for. HELP?