Counting Colored Icons in one sheet and putting the count in another ??

[bharath.blitz]

Hi Experts,

I have an interesting requirement.

1) I am using conditional formatting in a sheet1 to display traffic lights in a cell (Red, Green, Yellow icons)

2) When you enter value in sheet2 D4, this value appears in sheet1 H4 and based on a conditional formatting displays traffic lights in Sheet1 I4

3)This happens for some 40 different items

4)Now i have to calculate number of red, green, yellow icons and put that value in sheet 3 so that i draw a dashboard

Now how to count the number of icons of each color and put the value in another sheet?? Is this very complex?? I am a novice in excel macros, please help

 

[Ruddles]

I don't think you can count the conditional formatting icons, however you can use the same conditions you used to create the icons to create a 'helper' column containing the words 'red'/'yellow'/'green' or 'R'/'A'/'G', then use =COUNTIF to count those.

 

[bharath.blitz]

Thanks Ruddles...that was helpful