View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default Adding ONLY cells of certain color

Visit Chip at http://www.cpearson.com/excel/colors.htm

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kentucky Insurance" wrote in
message ...
Hello!
Can anyone tell me how to add only cells of a certain color? Whether it's
the cell's background color, or the font color, doesn't really matter. I
researched and seemed like SumIF was the correct function, but I can't
figure
out how to specify only certain colors.....
Thanks for your help.