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

[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 ;-))

 

[Frank Kabel]

Hi Jan
have a look at this previous discussion
http://tinyurl.com/3xr9b

 

[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 ;-))

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