Highlight D2:D9, then try these four formulas to apply with the colors you choose:
Rule #1: =D2-TODAY()<60 [RED]
Rule #2: =D2-TODAY()<90 [AMBER]
Rule #3: =D2-TODAY()=90 [YELLOW]
Rule #4: =D2-TODAY()>90 [GREEN]
Let me know if that helps.
- Moo
Highlight D2:D9, then try these four formulas to apply with the colors you choose:
Rule #1: =D2-TODAY()<60 [RED]
Rule #2: =D2-TODAY()<90 [AMBER]
Rule #3: =D2-TODAY()=90 [YELLOW]
Rule #4: =D2-TODAY()>90 [GREEN]
Let me know if that helps.
- Moo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks