I have a worksheet that is comparing a bunch of text against a template and coloring the box based on how similar it is to the template. I needed to get a code that could count how many are green(good) and how many are red(bad) and I then have this number referenced in the back which is further used to create a pivot chart in the first sheet. My issue is that when I first open the file I get these #VALUE! errors seen below (https://i.sstatic.net/GPd2sI6Q.png) and it really confuses me because I click the box and hit the enter button and the code runs just fine and gives me the results below (https://i.sstatic.net/Yj8CJiCx.png) I am using the code below to count the colors