Count the cels with the same collor made with conditional formatting!

F

Freesurfer

Hi all,

Who nows how i can count the collor cels (red-green-yellow) in my worksheet!
I'm using conditional formating to collor them.
I need the sum of all cels with the same color to put them in a chart.

Thanks!

Greetz,

Jan ;-))
 
R

Ron Rosenfeld

Hi all,

Who nows how i can count the collor cels (red-green-yellow) in my worksheet!
I'm using conditional formating to collor them.
I need the sum of all cels with the same color to put them in a chart.

Thanks!

Greetz,

Jan ;-))
Click to expand...

You need to count them using the same formula that you used for conditional
formatting.

If that formula is simple, COUNTIF could be used.

If that formula is complex, then an array formula or SUMPRODUCT may be
required.

If you post the conditional formatting formula, we can probably help.


--ron
 
Top