Changing tab color conditionally

chamblessw

New member
Joined
Mar 10, 2013
Messages
7
Reaction score
0
Points
0
Can I use binary info (yes no) generated within the spreadsheet to change the color of spreadsheet tabs? I will use 20 tabs to keep up with the status of my trucks. I want to be able to visually see which trucks or in or out of service. I will ignore in service tabs and attend to out of service tabs. How can I do this?
 
You would need VBA and event code within the worksheet to set the colour.

Wouldn't it be simpler to have a summary worksheet that shows all trucks and their status?
 
Yes, I will have a summary spreadsheet. I wanted the alternative of one-step seeing which tab needs attending.
 
Back
Top