I have a workbook with 51 worksheets, one being a master. I would like to change the tab colors of the worksheets based on cell values on the master worksheet. There is a list of 50 cells on the master sheet that correlate to the 50 worksheets. The data in the cells on the master contains the number of students registered for a class. If the number is equal to or greater than 6, I would like the tab on the corresponding worksheet to turn green. Less than six it will be yellow.
I understand how to change the color on individual sheet sbased on cell content, but I'm struggling a bit with this one.
I understand how to change the color on individual sheet sbased on cell content, but I'm struggling a bit with this one.