L
L
lukoie2019-04-29 01:26:46
Spreadsheets
lukoie, 2019-04-29 01:26:46

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

1 answer(s)
R
Roman, 2019-04-29
@lukoie

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 question

Ask a Question

731 491 924 answers to any question