Hi, I'm looking to take a group of 31 excel workbooks, loop through them, get the value from the same field (M7), which is of the General format, and get a sum total for all of the workbooks. What I'm stuck on is how to get the data from excel.Using column A as the helper column, enter the color name into cell A1. Next Conditionally Format B1 using the "Cell Value Is" and "Equal To", value of 1. Set fill color to Yellow. In cell B1, use this formula: =IF(A1="Yellow",1,"") As I said, this is a very limited workaround. BTW, why do you need to know the color of the cell to get a certain ... To get cell content with a given row and column number, you can use the ADDRESS function together with INDIRECT. In the example shown, the formula in G6 is: = INDIRECT(ADDRESS(G4, G5))