How can I count cells of a specific colour (pattern)?
 

We have a 'calendar' worksheet which users complete to record holidays,
special leave etc. Cells are given different colours (using format cells,
patterns) to represent different types of leave. Is there any way to count
the number of each colour of cell - for examle the number of red patterned
cells in each row? Product is Excel 2000.
Thanks

How can I count cells of a specific colour (pattern)?
 

See:

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


--
Gary''s Student


"Nick@Durham" wrote:

We have a 'calendar' worksheet which users complete to record holidays,
special leave etc. Cells are given different colours (using format cells,
patterns) to represent different types of leave. Is there any way to count
the number of each colour of cell - for examle the number of red patterned
cells in each row? Product is Excel 2000.
Thanks