EXCEL 2003 – CONDITIONAL FORMATTING
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 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?
Software/Hardware used:
Software/Hardware used:
ASKED:
April 10, 2009 2:40 PM
UPDATED:
March 1, 2010 3:20 PM
Answer Wiki:
I don't think that conditional formatting is the way, if I were in your shoes I'd rather search for VBA code that is triggered on a value change in the given cell.
---------------------------------------------
For column W use this: IF(Z="","UNSENT","SENT")
You could try this in column W:
IF(Z2="",L2+30,"SENT")
that will put the word SENT in the column W if there is something entered in column Z
but if nothing exists in column Z then it would put your formula in from earlier
Hope that helps
To see all answers submitted to the Answer Wiki: View Answer History.
Try this in W
=IF(Zx=”",Lx+30,”Sent”)
IF the date_submitted is blank THEN add 30 to the Start Date. Else, enter ‘Sent’ in that cell.
Now, highlight your L Column and format those cells with the Date format that you want. If you enter 12/14/08, the format could show that cell as December 14, 2008. Do the same for the other columns.
If you get ‘#######’ in the cell, widen the cell. You should see the date.