Hi John,

I am still learning VBA, and coding this would be a bit tough for me. Therefore, I might need your expert advise to apply the below patterns for levels via VBA to my org chart.

Level 1 (The head) - Blue
Level 2 - Green
Level 3 - Purple
Level 4 - Yellow
Level 5 - Orange
Level 6 - Grey
Level 7- Magenta
Level 8 - Violet

Awaiting your help.