Macro to count coloured rows

**[email protected]** · 01-13-2012, 09:29 PM

Please I need help with this task,.. even though looks simple,.. its complicated to me with macros...

I need a macro to count the RED and GREEN cells within Column K, in the attached workbook,..and populate the value in cell N and cell O,.. please open the attached workbook,,.. for a better understanding of this request..

I really appreciate any response at all,..

regards..

**jolivanes** · 01-14-2012, 12:49 AM

Give this a try on a copy of your workbook.

Please Login or Register  to view this content.

If you have Cells in Column K that are not colored Red or Green and you need these in your total count in Cell Q2, use this.

Please Login or Register  to view this content.

**jolivanes** · 01-14-2012, 03:19 AM

Cleaned up a bit

Please Login or Register  to view this content.

**[email protected]** · 01-14-2012, 10:13 AM

Thank you very very much,,.. You are nothing but a Genius,..

Thanks alot,..

**Mordred** · 01-14-2012, 11:32 AM

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**jolivanes** · 01-14-2012, 12:35 PM

Mordred
Is the "Your post does not comply" etc meant for me? Could you be so kind and let me know what I should change in answering please, if it is indeed for me.
Respecfully yours

John