formating cells in date range

Copper Contributor

I want to have cells with dates that are 90 day or less highlighted.  I am confused and not an excel kind of person. Help?

2 Replies

Select your cells, Home->Conditional formatting->New Rule->Use a formula..

Add a formula like this (assuming A1 is the first cell of the range) and apply desired format

image.png

 

you rock! thanks