Change color of cell when different cell has data entered

B

B J G

I have a spreadsheet that contains data for shipping information from a
separate spreadsheet. I have several things I want to accomplish and not
sure how to do it. Your help is appreciated.

What I did was set up a second spreadsheet that is viewed by a different
office. The information in their spreadsheet is pulled from a spreadsheet in
our office. I did the following formula (entry):

='[VentSure Day Tracking.xls]VentSure Days Fiscal 2008'!A58 (this is the
information in Cell B3)

I want the cell B3 to change to hot pink when data is entered into cell K3
on the same worksheet.

I also want the enire row except cells R3, S3, AE3 & AF3 in the original
worksheet ('[VentSure Day Tracking.xls]VentSure Days Fiscal 2008'!)to also
change to hot pink

I hope this is clear enough to understand what I'm trying to do. The color
change to pink will notify those that need to know that the shipment has gone
out.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change the colour of a neighbouring cell 6
Change Color of cell 3
Data change color when entered 3 times 1
Lookup function - Wrong info when I add lines to reference spreads 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
How do I change the color of the cell pointer? 7
Hide Values when data has not been entered into a cell. 1
autofill colour based on date entered 4

Top