I have three columns, A, B, & C. All will have dates in the 01/01/1900 format in them. What I want to achieve is the following: When a date, any date, is entered into A2 that cell will turn to be shaded green and also cause the date in B2 to set three days out and automatically turn shaded yellow. I've gotten this far on my own. My problem is with the next step. I know what I want but haven't been able to rank the conditions to get the right results. If the date in B2 is between 1985 and today's date (which will be variable then) I want it to turn shaded red but only if C2 is blank, if C2 has a date entered I would like B2 to go back to white. Help?