View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aslam Aslam is offline
external usenet poster
 
Posts: 5
Default Couting based on color and Filter

hi

I have a data more than 1000 rows, most of them highlited with
different colours, my question is: Is it possible to count based on
specific highlited colours for example yellow= 50 row, blue= 70, red
=105.

In addition to this, in excel-2003 the auto-filter does not display
more that 1000 row, is it have any solution

thanks