See Chip Pearson's site for working with the colorindex of cells.

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


Gord Dibben MS Excel MVP

On Fri, 19 Jun 2009 08:12:01 -0700, Khalil
wrote:

Dear Experts;

My data is consist around 100 row, most them highlited with different colors;

I need to do the following; Please help me

1.. Count by Color
2.. Sum by color
3.. Filter by color

thanks in advance
khalil