Hi, I am working with a tracking schedule for my job, and I am trying to impliment conidtional formatting into it, but some of it it just not working for me. I am working with Microsoft Excel 2003 and I was wondering if you could help me with my problem. Column B = Start Date Column C = Due Date - Each cell in this column is coded =SUM(B2+30) which tells me the date that it should be due. Column D = Submission Date What I would like to do is have cokors warning me when the due date is approahing such as: - I would like the dates in column B to turn orange when 2 weeks have passed from the start date. - I would also like the dates in column B to turn red when 3 weeks have passed from the start date. - The last thing I would like this column to do is when I fill a date out in column D that means they handed it in and I would like the dates in column B to revert back to normal black font. I do not know if this is highly complicated, but I have been working on this for a while and I just cannot seem to get it right. So if you could help me out i would be very happy :)

Software/Hardware used: