Forum Discussion
Count Conditional Formatted Cells
I am trying to create a formula in Column/Row P3, P4, and P5 that will count the number of conditionally formatted cells in Column I3:I24 based on the color of the cell. I have attached an example ...
CoadyKrZY , I'd change a bit formulas for conditional formatting rules to exclude blanks, like (for red)
=AND(E3+5 < TODAY(),LEN(E3)>0)
Relative counting, as in previous post, like
=SUMPRODUCT(($E$3:$E$24+5 < TODAY())*(LEN($E$3:$E$24)>0))
Similar for another colors, added in attached file
Of course, that's only one of variants.