Sorting by colour

SngTao · Apr 4th 2005

Hi guys,

Right now, I have an excel spreadsheet which displays the progress of the project by the cell colour(namely blue and red).

Does excel allow me to write a macro to calculate the total number of blue and the total number of red cells?

Thanks

**Jack in the UK** · Apr 4th 2005

Re: Sorting by colour

How are You colouring the cells Fill Colour of Conditinal formatting?

Your subject title says 'sort' maybe this should be edited to count by colour

jiuk

**Jack in the UK** · Apr 4th 2005

Re: Sorting by colour

Just thinking our very own Dave Hawley has covered this very well click here for link and there is lots of extra information You might find extreamly helpful

jiuk

Sorting by colour

Participate now!

Share