Counting Number of Colors in a sheet (not Number of Colored cells)

[zanac]

Team,
i'm trying to count the number of colored groups (how many colors groups not how many colored cells). Appreciate any help or guidance on that request?
note: its a huge database, and my example below is just to explain my request.

please note I want this to be solved in vba not formulas , Thanks

21976

[YasserKhalil]

Have a look at this link
http://www.vbaexpress.com/forum/showthread.php?61655-Count_Colours_Not_Duplicate

[Paul_Hossler]

Would this still be 5 groups or would it be 6?

21980

[Tom Jones]

Cross post.
You get an answer here:Counting Number of Colors in a sheet (not Number of Colored cells) (https://www.excelforum.com/excel-programming-vba-macros/1226540-counting-number-of-colors-in-a-sheet-not-number-of-colored-cells.html)