Results 1 to 3 of 3

Thread: Changing tab color conditionally

  1. #1

    Changing tab color conditionally

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?

  2. #2
    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?

  3. #3
    Yes, I will have a summary spreadsheet. I wanted the alternative of one-step seeing which tab needs attending.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts