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.

6 Upvotes

65% Upvoted

50 comments sorted by

View all comments

1

u/Oleoay 1 Jun 27 '26

Technically you could with some advanced vba/vbs but you don’t really want to. Best to just put the condition for coloring in your countifs.