counting cells

  • Thread starter Thread starter al
  • Start date Start date
A

al

Hi All,

Is there a way to count the conditional format cells for e.g if I have
10 cells that I am turning Green if condition is true can I count
these Green cells and display "Pass" in that cell?? Or I would have
to write a macro do do this?

TIA
 
Write a formula that counts the number of cells that pass the CF
criterion. For instance, if the CF is

cell value is greater than 100

then use

=IF(COUNTIF(A1:A10,">100")=10,"Pass","Fail")
 
Back
Top