Good Afternoon,
I am developing an inspection matix for my fire department and i have run into a slight snag. I have set it up so that when an inspection date is entered it will automaticaly enter the reinspection date that is 30 days out from then and the new inspection date that is 180 from the inspection date. This much i have accomplished. The main problem is the reinspection date. I am trying to figure a way to make the cell turn green when a date is generated, yellow 10 days from that date, and red on day after. with that when a date is entered in the reinspected date cell it will turn the color of the cell green, yellow, or red depending on when it was done. I need help of guru's of excel wisdom.