Thanks Gary,

Got it to work, but if the range's color is changed by conditional
formatting CountByColor does not work?, any ideas?

"Gary''s Student" wrote:

See:

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

for a very good explanation
--
Gary''s Student - gsnu200726


"LaDdIe" wrote:

Hi,

Is it posible and how, to count number of cells in a range that are a
perticular fill colour.

Thanks