View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hamish Hamish is offline
external usenet poster
 
Posts: 14
Default Counting the number of Cells with a Particular Background Colour?

Hi

I have an Excell sheet with about 200 lines. My results are calssified in
Columns in 5 Different colours. I would like to automatically count the
number of cells with a particular background colour in each coloumn.

For example:

Look at one whole column and count how many cells have a green background.

is this possible?