I have been trying to figure out how to count the number of times a cel
is colored using conditional formatting.

I have looked through the old threads and still cannot find
solution.

I need to add up the # of times a cell is a certain color (Green) in
particular row.

However, the criteria for the cell to become green is different fro
row to row. In most of the rows, there is only one condition whic
highlights the cell green; it is left blank if it doesn't satisfy thi
condition. In others, there are two conditions: one that highlight
green and one that highlights red. I need to add up the number o
green and red in the row.

I have done searches on this topic before and was pointed to a websit
which tries to explain a VBA code for this.

However, I cannot make heads or tails of this.

If anyone could help, I would greatly appreciate any suggestions.

Thanks.

DrSues0

--
DrSues0
-----------------------------------------------------------------------
DrSues02's Profile: http://www.excelforum.com/member.php...fo&userid=1256
View this thread: http://www.excelforum.com/showthread.php?threadid=27070