Excel color retrive with drop down list

Hi i created an excel file with Cyprus League teams. I made a drop down list with these teams in a sheet named teams. i colored each team with its official color. i have a separate sheet named rounds. when i select two teams for example it does not come with the color as created.any idea of how to retrieve color also?

attached is a sample picture of what i mean

thanks a lot

Hi there,

You can't really get the formatting into the cell directly from the drop-down list, but you can do it with conditional formatting.

1) Select the cell with the drop-down list
2) Home tab --> Conditional formatting --> highlight rules --> text that contains
3) Here select the first cell that holds the name of a team
4) Click the drop-down list next to the field that currently says "Light Red Fill with Dark Red Text" and click 'Custom format'
5) Format the cell

Now do this for each team, everytime selecting the next team in 3)

hi Kasper,

thanks for your reply,

i have already did that. i was wondering i can do what i described above.
thanks anyway for your effort

Alright.

Well, it is possible with VBA.

Can you upload the file?

hi Kapser,

please find attached.
names are in Greek but i don't think that this will be a problem.
thanks a lot

Hi there,

I hope maybe someone else could pitch in.

The problem is that I'm creating a macro that runs on an event (when the cell content is changed via the drop-down). And when that is changed, the code runs which also changes the content of the cell. So I'm getting some errors on it.

Are there someone that can think of a fix?