Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

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.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .