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 :)