Dear vletm Sir,
Would You reread Forum Rules:
There is a line as below:Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...chandoo.org
You've posted Your thread to VBA Macros ... then You have had a clear idea to get VBA Macros -solution --- then I won't even think to offer any formulas.
- Please post, new posts in the correct forums, not as Emails/Messages to people
What would mean You term simple?
Normally, it would mean double work!
My previous solution works with Your newer file as well - but the results comes as it You can see from this file - click three times.
Your sample colors ... could figure as those colors ... but to compare color to color would work.
If You have more than 600 rows ... then why You give six rows as a sample?
... and this works even if there would be less than 600 rows.