formula

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

Bit of a newbie to Excel, forgive my ignorance.
I have a very simple spreadsheet containing on average 50 rows, of which the
text is in three different colours in column "A", is there a solution that
can count how many of each colour there is?
Also as the number of rows changes between 40 and 60 daily, which cell would
I use for the formula as I have no definitive end to the rows, although it's
unlikely to be any more than 60, any idea's?
 
You have to use some code to get the color (font or Fill) of a cell.

Chip Pearson has some code already for you at:
http://www.cpearson.com/excel/colors.htm

And maybe you could just use the whole column:
Kind of like with =sum().
=sum(a:a)

or just stop at 100 (a little more than 60)
 
Back
Top