View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default conditional formatting highlight dates 90 days or less

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?