Counting colored cells

Hello !

Is there a way to count a cell depending in its color? I'm working with a basic scorecard (greens, yellows and reds) and I wolud like to score it automatically. Cells are using conditional format.

Thanks ..!

Carlos

i dont think there is any formula in excel for counting colored cell values, however the same is possible if its done with the help of macro. please share the excel and i will try to solve your issue if you want it done with macro.

Wasim

Hi

Do a advanced search on this forum, the subject as been posted many times!

http://www.excelforum.com/search.php?searchid=496778

Thank you so much..!
The thing is that I forgot (I thought was not relevant) that cells are using conditional format and apparently it does not work becuase of that. I really appreciate your help...!

Carlos