Conditional Tab Colors

  • Thread starter Mike Williquette
  • Start date
M

Mike Williquette

I am creating a multi-tab spreadsheet that will be used to record employee
businesses expenses. Our organization will receive these documents from
employees by e-mail. Our practice is to PDF all such documents.

While each employee will use the same Excel business expense spreadsheet,
not all of the pages will be used by each employee. Therefore, in order to
speed up the process of PDF conversion and at the same time save disk space,
I would like to find a way for the page tabs to turn red when its page has
been used by the employee. If a page has been used, the "TOTAL" cell on
each page will have a value other than zero.

Therefore, is there a way to turn a page-tab red when a particular cell on
its page is a value other than zero?

Thanks,
Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top