How do I write that formula? I tried =COUNTIF(N1:N382,"<today()") , but
it doesn't work.



"JE McGimpsey" wrote:

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?