Change cell color

M

Mir Khan

Hi Experts, I am looking for something for more than a week and I am still
struggling with it.

I have total 3 sheets in this workbook and I need a macro that will involve
2 out of 3 worksheets and they are “FloorPlan post restack†and “Data Sheetâ€.

“FloorPlan post restack†worksheet has FloorPlan that has seating
arrangement of the floor with cube # and other information. “FloorPlan post
restack†will be pulling information from “Data Sheetâ€. “FloorPlan post
restack†is color coded based on managers, whenever there is a change in
manager we make the change in "Data Sheet" and manually change color of the
cell, which should be handled by Excel.

What I want is when we change manager in “Data Sheet†the designated color
for the manager should change by Excel in “FloorPlan post restackâ€. I tried
conditional formatting and it work great for 3 managers (conditions) but I
have 5 managers altogether and we might have more managers in future and
hence I am looking some code that will serve my purpose.

Please let me know if you need any additional information.

Please provide me with your email address where i can email you the Excel
file if you would like to take a look at it.

I appreciate your help and time.


Mir Khan
 
M

Mir Khan

Mir Khan said:
Hi Experts, I am looking for something for more than a week and I am still
struggling with it.

I have total 3 sheets in this workbook and I need a macro that will involve
2 out of 3 worksheets and they are “FloorPlan post restack†and “Data Sheetâ€.

“FloorPlan post restack†worksheet has FloorPlan that has seating
arrangement of the floor with cube # and other information. “FloorPlan post
restack†will be pulling information from “Data Sheetâ€. “FloorPlan post
restack†is color coded based on managers, whenever there is a change in
manager we make the change in "Data Sheet" and manually change color of the
cell, which should be handled by Excel.

What I want is when we change manager in “Data Sheet†the designated color
for the manager should change by Excel in “FloorPlan post restackâ€. I tried
conditional formatting and it work great for 3 managers (conditions) but I
have 5 managers altogether and we might have more managers in future and
hence I am looking some code that will serve my purpose.

Please let me know if you need any additional information.

Please provide me with your email address where i can email you the Excel
file if you would like to take a look at it.

I appreciate your help and time.


Mir Khan
 

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

Top