testing for color of a cell

[jsniderfamily]

How do you test for the color value in a cell?
Maybe the background color is red or blue or cyan and I want to test for it to know how many cells are a certain background color.

[VBA Noob]

Links should help

http://www.xldynamic.com/source/xld.ColourCounter.html


http://www.cpearson.com/excel/colors.htm

VBA Noob

[jsniderfamily]

thanks for the links