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

I'm just literally doing a 3-color scale like so:

Minimum: =($L$3-TODAY())<7

Midpoint: =($L$3-TODAY())<14

Max: =($L$3-TODAY())>14

I thought this would be correct but it won't format anything :|

I'm trying to do three things:

  • RED if TODAY() or 7 days before
  • YELLOW if TODAY() between 7 &14
  • GREEN everything else so TODAY()>14

Can anyone see anything wrong with that? I don't understand why it isn't correct :)

share|improve this question

Eventually solved it myself:

Minimum: Less than NOW()

Midpoint: Between NOW() and NOW()+7

Max: Greater than NOW()+7

share|improve this answer

You must log in to answer this question.

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