Auto Cell color

Hi all
I am a bit of a novice, so hope i explain what the problem is correctly. I have 3 teams Red, Blue and Green, with 5 members in an team.I need to depict each members name with the correct team colour in a cell and there name. However i need it to change the cell colour when i select the members name from a drop down list. The drop down list is not a problem its getting the cell to colourize to. Hope this is explained sufficiently enough. Would be grateful of any help.

to walk you through it depends how you did the list. You can get by with using conditional formatting as long as you only have 3 colors. you will want to go to Format/conditional formatting. Select Formula is then use a formula similar to

=COUNTIF($G$2:$G$6,A1)

in the example G2:G6 are the cells that contain the names of the red team for instance, and A1 is the current cell. then set the formatting to cell color of red. then click the add button for the other two teams.