Count coloured cells

[J]

Does anyone know how to count the number of cells in a column that are coloured?

 

[Don Guillett]

any particular color?
colored how_____regular way______conditional format_____?
xl version

--
Don Guillett
SalesAid Software
[email protected]

Does anyone know how to count the number of cells in a column that are

coloured?

 

[Paul B]

J, see if this will help http://www.cpearson.com/excel/colors.htm

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

Does anyone know how to count the number of cells in a column that are

coloured?

 

[J]

Hi Don,

For the moment I just need to count all of the cells that are coloured (using the format toolbar and fill color) in a column and all that are not.

J