use the same condition in the CF in the formula...

In article ,
"Cachod1" wrote:

I have a column with conditional formatting (criteria 1 = green highlights /
criteria 2 = red highlights). I need to calculate percentages of the red
highlighted cells against the total # of cells (green and red). How do I
count only the red cells so that I can get the percentage?