Hi, I'm quite new to Visio (so apologies if I incorrectly reference items) and am struggling with something that I expect is relatively straightforward.

I want to create an Org Structure template I can use to import values from excel and each time I do that, when a role is Grade = A1 the shape is blue, Grade = B2 the shape is green, and so on. This is an example of the data.

Grade /Position /Reports to /Number of posts /Area of work
A1 Director Nil 1 SLT
B2 Deputy Director Director 1 SLT
B2 Head of Security Director 1 Security
C3 Guards Head of Security 3 Security
C3 Finance Deputy Director 4 Finance

Any help greatly appreciated!