Reading and Counting Cell Values Via Macro

[Anonymous]

I have 18 straight charts grouped into 6 sets, so each set has 3 charts. Each chart has one Dimension (client) and one Expression (Sales). Need to create a Macro that reads each set (3 charts at a time), count the number of times Clients appear in each set, if:

Count(Client) = 2, make the background color of that row (Dimension and Expression) Blue

Count(Client) = 3, make the background color of that row (Dimension and Expression) Green

Then read the next set and so on.

Attached is the sample.

Any suggestion would be appreciated.

Thank you.

[Gysbert_Wassenaar]

See attached example.

[Anonymous]

Thank you G Wassenaar, I can't assign Table and Group fields in the data model because of it's size and complexity.

Trying to achieve the grouping on front-end (sheet level)