Hi Marc,

http://www.cpearson.com/excel/CFColors.htm

use the Chip Person tips.

hth
regards from Brazil
Marcelo

"Marc" escreveu:

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