Hi, I have a cell with user entered date in it. This date needs to updated at least once every calendar month. So if the date entered is 6/11/15 then the cell needs to be updated at least once in July sometime.
So, I want the cell color to prompt them when that following month is winding down. If the displayed date is 06/11/15 then I want the cell fill color to turn yellow when 7/21 rolls around and red on 7/28. I need it to do this for all months. If the entered date is 10/01/15 then I need it to go yellow on 11/21 and red on 11/28. Get it? Did I explain that well enough?
So, I want the cell color to prompt them when that following month is winding down. If the displayed date is 06/11/15 then I want the cell fill color to turn yellow when 7/21 rolls around and red on 7/28. I need it to do this for all months. If the entered date is 10/01/15 then I need it to go yellow on 11/21 and red on 11/28. Get it? Did I explain that well enough?