How to change cell color based on today's date in Excel 2010

Solution 1:

You can use conditional formatting. Use the condition =NOW() + 90 with the Less Than... condition.

Choose whatever color format you want.

If you want to have multiple colors you can have multiple rules with different conditions where you vary the 90 from the above condition.