Excel doesn't have a built in way of doing this, however, you can use a macro
to do it: http://www.cpearson.com/excel/colors.htm

Post back if you have questions.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"VTN" wrote:

Hi,

I have a worksheet that has data in cells which has also been color coded.
What I would like to do is find a way to search for, say, all of the yellow
cells in the worksheets and sum the numbers in those cells. And then, of
course, do the same for all of the other colors in the worksheet.

I thought I could perhaps use a sumif where the criteria is "if the cell is
shaded yellow" but I don't know how to set that criteria up. Does anyone
have a way to do this?

Thanks!