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?
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 498 |
Nodes: | 16 (2 / 14) |
Uptime: | 51:01:32 |
Calls: | 9,810 |
Calls today: | 12 |
Files: | 13,754 |
Messages: | 6,190,346 |