Combining search and conditional color formatting for a small database

Let me first give a short introduction, which might make my problem easier to understand.

I play a game called Darkspore. In this game you have three squads. Each squad consists of three heroes. Each hero has a few properties:
Type: Bio, Cyber, Necro, Plasma or Quantum
Role: Sentinel, Ravager or Tempest

What I want to make is an overview of my three squads, something like this:
\1

Columns A through F hold my current squads. H through M hold the distribution of types between my squads.

Let me give an example of what I want to be able to do. The image shows how it should look like in the end after filling every name. At first, without any names, everything should be empty and there shouldn't be any colors.

Now if I for example enter Zrin in squad 1, then the cell with his name should become red, because he's a plasma type. The little square next to his name should become black, because he's also a sentinel. On top of that the cell that stands for a Plasma type in squad 1 should also turn red (in the second table).

I already have a list with all relevant info, it looks like this:
\1

So my first question would be, is this even possible?

I was thinking of something like this:
- First you enter a name
- It gets compared to the list and returns the row it's in
- Use (D*Result*) and conditional formatting to color the cell in which I just entered the name
- Use (E*Result*) and conditional formatting to color the little square cell next to the name

This should take care of the first table.

Now on to the one that shows the distribution of types. Ideally you would be able to compare background color. For (Bio,Squad1) it would be something like this:
If(A2.getBackgroundColor() == Colors.Green || C2.getBackgroundColor() == Colors.Green || E2.getBackgroundColor() == Colors.Green) { this.setBackgroundColor(Colors.Green) }

If this isn't possible, it might be helpful to use the results from the other table and just looking up the type again.

Even though I'm saying all this, I got no clue as to how to implement this in Excel. I hope someone here might be able to get me started. Or if someone knows a better / easier solution, that would also be nice .

I added the Excel file as an attachment.

Conditional formatting with vlookup as a formula does the trick for the characters and conditional sums based on vlookup does the trick for the conditional format of the character distribution.

To check it out, simply click where you'd like to change the character and a dropdown will appear for you to choose a different name.

See if this gets you underway.

You should checkout the named range I have added "NamesList", it contains duplicates. I think you might need to base your final sheet on Sheet "Darkspore Data" Column "Complete Name" not "Name".

Hope this helps

[EDIT]

Okay the duplicates are caused by the variant types, so a reduced lookup list should do the job.
I have updated the attachment.

That last request will need VBa

See the attached for the code and where it goes.
To make references easier I have added some more named ranges, these are now dynamic so you can add names and data as required.

Hope this helps