Count amount of cells with specific color with value

Hi

I only want to count the amount of cells of a specific color that contain a value above 0.

Hi Ikke1996,
maybe so

Please Login or Register  to view this content.

That works!
How did you find the number 10079487?
Can you maybe do a breakdown of the text? Or do you have a source where this text and its function are described so i can understand what's going on?

select the cell with the desired color and run the macro

Please Login or Register  to view this content.

Nice!

Is it possible to, instead of putting in a number, to select the cell with the desired color?

Please Login or Register  to view this content.

=CountColor2(D2:D21;B9)

Aha, works perfectly, thanks!!