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?
|