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

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy and paste. 1
Any formula to count number of cells with a specific color pattern 2
Count how many times conditional formatted cells are positive 1
count nonblank cells with conditions 2
How do I count cells that contain a number of charctors. 3
How can I count the number of cells with a particular color/shade 2
Count for specific format? 8
chosing cells with a specific colour and taking average value from 3

Top