See

http://www.xldynamic.com/source/xld.ColourCounter.html
Processing Coloured Cells

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Maileen" wrote in message
...
Hi,

I have a sheet ("January") in which some cells are colored with particular
color, i would like to know if exists a method how to detect these
particular
cells and to count their number ? (if possible without using VBA).

thanks,
Maileen