COUNT using coloured cells
Posted by Deirdre on August 30, 2001 12:06 PM
Columns A and B are not related but simply sums of other cells in their resoective rows.
I have conditional formatting set if B > A then it is to colour the cell red and the font yellow.
What I would like to do is COUNT the number of Red Cells in column B.
I've seen some examples on this message board, but they are for adding the values I believe in the coloured cells. I simply just want to count the number of occurrences in a column range.
Your assistance is much appreciated.