How do I Change cell color in Excel 2010 for upcoming or past dates based on 90 days from today. I would be great if I could use 2 color scale but one color will be fine.
You can use conditional formatting. Use the 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