formula

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?
 
D

Dave Peterson

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)
 
Top