Answer the question
In order to leave comments, you need to log in
How to count the number of cells with conditional formatting?
Hello
Let's say I have a column where I use conditional formatting to mark all the cells of such and such a date in green.
How can I display the number of such cells below?
Answer the question
In order to leave comments, you need to log in
Hi
If this is how you solve the problem, then you can’t do without a script - take the color of the cells into an array and count the number of elements of the desired color.
But why can't you repeat the logic of conditional formatting in a formula with COUNTIF?
Can you give an example file?
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question