Hello All,

This is a bit of a tricky one.

I am working on a macro to add together all the cells for rows that are orange [RGB = FFCC99], yellow [RBG = FFFF99] & gray [RGB = F2F2F2] in the tab titled Summary. So if T2 is orange in the summary tab, add together T2 in sheets 1, 2 & 3 that may be labeled ABC, QRT & CBS in one file and another file may have 10 different tabs that all need to be added together with entirely different names.

The reason I want to go with RGB is because there are over 10,000 cells that need to be filled and the structure won't allow for looping or a standard offset. There are formulas that will be driven from the added numbers and can't be overwritten but they are all filled with different colors.

I appreciate any input on this, I always give reputation when it works!