I'm using Excel 07; I need to set conditional format based on dates. Row "C"
projects 4yrs 6months from "B"; I need each row to change colors based on:
"C" is less then today's date ($C2<TODAY()); Today's date is within 6months
of "C"; Today's date is within 90days of "C"; and today's date is within
30days of "C". I would appreicate any help. Thanks

B C
2008 05 06 2012 11 06