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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Back
Top