systemsrool
New Member
- Joined
- Nov 5, 2015
- Messages
- 14
Hello,
I have a list (drop-down menu) in Cell B7 on my "Customer Info" tab that has 4 options (Flow Rack, Workstation, Machine Guarding, and Other (custom)).
When I select Flow Rack in the list I want the Flow Rack tab to turn green and the following tabs turn red.
Basically; If(B7="Workstation") then... Tab "Workstation" = green.. and tab Flow Rack, Machine Guarding, and Other (custom) = red.
Customer Info should stay white.
All help would be much appreciated. Thank you in advance.
I have a list (drop-down menu) in Cell B7 on my "Customer Info" tab that has 4 options (Flow Rack, Workstation, Machine Guarding, and Other (custom)).
When I select Flow Rack in the list I want the Flow Rack tab to turn green and the following tabs turn red.
Basically; If(B7="Workstation") then... Tab "Workstation" = green.. and tab Flow Rack, Machine Guarding, and Other (custom) = red.
Customer Info should stay white.
All help would be much appreciated. Thank you in advance.