Counting Conditional Formatted Cells

  • Thread starter Thread starter randysbug
  • Start date Start date
R

randysbug

Is there a way to count cells in a row that are filled red. I don't car
what the value is in the cells I want to count, I only want to know ho
many cells in a range is filled red.

Many thanks!
Juli
 
Hi
not really possible (Harlan Grove / Bob Phillips posted once a UDF that
checked the conditional format conditions directly). Problem is that
the conditional format does NOT change the colorindex property of the
cell.

So the easiest workaround would be to check for your conditions
manually (e.g. using sUMIF, COUNTIF or SUMPRODUCT)
 
Back
Top