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 L = Start Date
Column W = Due Date
- Each cell in this column is coded =SUM(L2+30) which tells me the date that it should be due.
Column Z = Submission Date
What I would like my file to do is when I enter in a date in column Z, the cells in Column W will be affected and say "SENT" instead of a date.
Do you know how I can go about doing this?
April 10, 2009 2:40 PM
March 1, 2010 3:20 PM