Thread: Cell Color change by state of other feild

Hi all I'm new here. If anyone can help me I would greatly appreciate it. I'm playing with an excel file that has 3 different spreadsheets and basically the same layout just different product lines on each sheet. I need to find a snipet of VB code to change cell color depending on if another cell is used(filled in) or if it is blank. I'm very limited to my VB skills but can tinker enough to get what I need if someone points me in the right direction.

here is an example of what I'm trying to accomplish using the following Columns:

ItemNo[A], QUOTEREQUESTDATE[B], SUBMITTOSALESDATE[C] APPROVALRECEIVEDDATE[D], RELEASETOMFGDATE[E]

EXPECTED RESULTS TO CHANGE CELL[A] COLOR TO RED CELL:
[B] USED, [C] BLANK, [D] BLANK, [E] BLANK

EXPECTED RESULTS TO CHANGE CELL[A] COLOR TO ORANGE CELL:
[B] USED, [C] USED, [D] BLANK, [E] BLANK

EXPECTED RESULTS TO CHANGE CELL[A] COLOR TO YELLOW CELL:
[B] USED, [C] USED, [D] USED, [E] BLANK

EXPECTED RESULTS TO CHANGE CELL[A] COLOR TO GREEN CELL:
[B] USED, [C] USED, [D] USED, [E] USED

Thanks in advance for any help..
Click here to download a copy of the excel file.

Please check the attached file. If you have Excel 2007 you can use conditional formatting to accomplish your objectives.
You explained your situation very well.

Thanks for your help...I have Excel 2003.

I did not realize I was in the outlook programming forum...I have reposted this issue in the excel programming forum....Good looking out.
http://www.excelforum.com/excel-prog...ml#post2136091

Any further responses will be in that forum.