Correct, conditional formatting is the way to go. Set first box to "formula
is" then input:

=AND(TODAY()<=A2+90,TODAY()=A2-90)

Note that this assumes you mean "within 90 days" to be plus or minus. If
not, remove the appropriate part of the formula.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"JonnyP-SC" wrote:

I use a spreadsheet with lots of dates and need them to automatically turn
red if they are within 90 days of today's date. I believe I need to use
conditional formatting, but am not sure how to set it up correctly.