Thread: Counting the number of Cells with a Particular Background Colour?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Duncan[_5_] Duncan[_5_] is offline
external usenet poster
  
Posts: 290
Default Counting the number of Cells with a Particular Background Colour?
Try this site..

http://www.cpearson.com/excel/colors.htm


Duncan


Hamish wrote:

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?

Reply With QuoteReply With Quote