change text color based on another group of cells

[Guitarmageddon]

Hello everyone,

Here is an example of my data after all the other steps of my source macro are done. Essentially, just putting sorts on "ship-to" and "GROUP" columns at the end. Since everything is sorted into group columns and then given some cell borders to be easy to visually notice, I wanted to add one more text format.

For every same number group which has more than one distinct buyer within it, Id like to just make that font a color/bolded. Can anyone assist?

For example:

In the above source data, we would apply some VBA and it would come out like this:

The other unique groups have only one buyer involved, but group 7901 has more than one, so we apply the format. This would need to be looped to the end of the sheet, which is dynamic. Column A could be used as a reference to go until its blank then stop. It would be a given this VBA would be used within the total macro and all the sort context would already be applied by the time this little piece of code is executed.

 

[Micron]

I can tell you what I think the logic is based on my Access vba experience, but I'm quite the novice with Excel vba.

I think you will need to create an inner and outer loop. The outer loop would be from 2 (1st row with data) to the last row with data in the column of your choosing. I'd get the value of Group first, then do a count of that value in the column and pass that to a variable. In the inner loop, if that count is 1, exit the inner loop. The outer loop would then advance one row. Rinse and repeat. If the count is greater than 1, the inner loop would be from 1 to that count and would do the format that many times, using Offset. It would then exit the inner loop, go back to the outer loop and either repeat the process or exit because the outer loop would be done.