I currently have a spreadsheet with 38 tabs. Tab 1 is a summation of all the data entered on sheets 2-38. My issue is, that sometimes you'll only use very few of the 37 sheets that the summary pulls from. I want to find a way to easily know which of those tabs numbers are being entered into. I thought a good idea would be to force the sheet tab to change to a different color if it has numerical data entered into it. Each tab is identical, containing 4 different tables with different headers. I tried writing a code that says if a certain cell in each worksheet is not "0", then the tab color changes. The only issue I have is that people insert new rows into the tables to use the worksheet all the time, changing the cell number that I pull the value from. What is a workaround? I need the color to dynamically change as I add and remove values to tabs.