Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell color
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell color--please someone help
"Mir Khan" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
change fill color of a range of cells based on color of a cell? | Excel Programming | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
Browse Forms Controls and change TextBox color based on cell color | Excel Programming |