Excel 2003 – Conditional Formtting Help
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 :)
I got this for answer previously, but it still was not working. Does anyone have some advice for me???
Thank You
Software/Hardware used:
Software/Hardware used:
ASKED:
February 23, 2009 7:25 PM
UPDATED:
February 23, 2009 7:44 PM
Answer Wiki:
Here's a <a href="http://www.google.com/search?q=conditional+format+site%3Acpearson.com&rls=com.microsoft:en-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1">list of search results</a> from an excellent Excel resource. Hopefully one of these will guide you on the path to resolution.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
