Conditional formating and worksheet tab color

[dwhite30518]

I have a worksheet that with help from other Excel Forum users, I have created a macro that will create a pivot table of the data on the worksheet and then creates a calculated column next to the pivot table. The calculated column shows the variance between the two columns and shows how many devices are due back to the customer. Is there a way that I can a addition VBA so that when all of the calculated fields are "0", the worksheet tab gets colored green?

[MarvinP]

Hi,

I just turned on the macro recorder and colored the tab green. Find that code below. If you put this code in an if condition after a check of the calculated fields, it might do the trick.

Please Login or Register  to view this content.

[dwhite30518]

I kind of had that part figured out. I need help with creating the statement that checks for all of the calculated values are "0" and if yes then the tab color changes. Can you assist with that?

[MarvinP]

Say you add all your values to check and put the sum in A14.
Your code could be:

Please Login or Register  to view this content.

For a better answer or understanding of the problem we need to see a sample workbook.

[dwhite30518]

Here is a sample of what I am working with.

[dwhite30518]

I have a range of cells that all values must be "0" before the tab color changes to Green.