If your date is in D8 then use
=IF(AND(TODAY()-D8<91),(TODAY()-D860)) for conditional formatting

"Neal Ostrander" wrote:

How can I set the color of a cell based on the difference between the date
entered and todays date. For example if the date entered is equal to 90 days
but greater than 60 days away from todays date I want to color the cell
green.
Thanks in advance for any help.
Neal