See Chip Pearson's site for code dealing with CF coloring.
http://www.cpearson.com/excel/CFColors.htm
Gord Dibben MS Excel MVP
On Wed, 5 Jul 2006 11:01:01 -0700, Marc wrote:
hello -
I've conditionally formatted a column of cells to a yellow background based
on the sum of 5 other cells in the row.
Now I want to count the number of yellow cells. I don't know VB, so if
someone knows a formula method to count the cells, that would be great.
Thanks,
Marc