Newbie here with question. Excel 2007, have 1 column with 10 rows of numbers. I want an auto sum of the column, but only total the ones I have highlighted yellow or any color. Example 1 column, 10 rows, each row has the number 10. Only 7 of the 10 are highlighted a color so I want the auto sum to come out total 70, not auto sum 100.