EXCEL 2003 – CONDITIONAL FORMATTING

40 pts.
Tags:
Microsoft Excel
Microsoft Excel 2003
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Drodr05
    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.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following