try this

highlight the range or column
in CF under Formula Is, place this formula
=(TODAY()-A2)<=90
go to Format select your format / color
OK

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



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