Count coloured cells

  • Thread starter Thread starter Guest
  • Start date Start date
any particular color?
colored how_____regular way______conditional format_____?
xl version

--
Don Guillett
SalesAid Software
(e-mail address removed)
J said:
Does anyone know how to count the number of cells in a column that are
Click to expand...
coloured?
 
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 **
J said:
Does anyone know how to count the number of cells in a column that are
Click to expand...
coloured?
 
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
 
Back
Top