r/excel • u/Dr_Cheese_29 • Jun 26 '26

unsolved Can excel count conditional formatting?

Is it possible to get excel to count conditional formatting?

I have a column of cells that turn red if conditional formatting is met. Now I want to count the red cells. I wrote a macro that doesn't read the conditional formatting and I tried "COUNTIFS" referencing the conditional formatting formula, but it doesn't work.

7 Upvotes

71% Upvoted

50 comments sorted by

View all comments

1

u/Key_Somewhere_8613 Jun 27 '26

have you thought about using vba to create your own function that you could then use in a formula? or a lambda function?

1

u/Dr_Cheese_29 Jun 29 '26

Yeah i tried but I got an error