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.
![fe28291304.png](/board/proxy.php?image=https%3A%2F%2Fpuu.sh%2Fo177G%2Ffe28291304.png&hash=0dbe5b71e897723b0bf7b3f5bfe7be07)
![bac625f1d5.png](/board/proxy.php?image=https%3A%2F%2Fpuu.sh%2Fo17b9%2Fbac625f1d5.png&hash=9ff703a6756ef2868eb41b4dea982d4c)