On Thursday, July 2, 2009 at 12:53:14 PM UTC-5, 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 have this same issue but I want it to evaluate each cell date, not just in comparision to the first one. When I paste conditional formating to the following cells they are all evalutating based on the A2 cell and it needs to be based on the cell itself.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)