can some help me write a macro for a cell changing color from green to yellow to red base on completion date?
-Display green if status 'not started' or 'commenced' with due date equal to or greater than 30 days prior to todays date
-Display yellow if status 'not started' or 'commenced' with due date less than 30 days prior to todays date or, equal to todays date
-Display red if status 'not started' or 'commenced' with due date greater than todays date
-Display green if status equals completed
Thanks in advance
regards
Bookmarks