Conditional Formatting

[hotcomper]

I am using a list on 1 sheet for a drop down list on another. I have added colour to the list. (Each item is a different colour) is there a way so that when you use the drop down option that picks from the list the colours from the list show on your selection. (I have 24 choices on the list). I hope this makes sense. TIA

 

[vletm]

hotcomper
There is a way with VBA ...
It would need an Excel-file instead of Screen Shot.

 

[hotcomper]

hotcomper
There is a way with VBA ...
It would need an Excel-file instead of Screen Shot.

AS requested.

 

[vletm]

hotcomper
Something like this ...

 

[hotcomper]

hotcomper
Something like this ...

This is just what I want. Thank you so much.

 

[hotcomper]

hotcomper
Something like this ...

While I have an expert can I ask if there is a way if on sheet 1 you picked the same team on a row it will throw up an error?

 

[vletm]

hotcomper
Yes ... comment ... note ...

 

[vletm]

hotcomper
... but WHY would need to throw up something?
Would if smoother to let select only 'free team' like this?

 

[hotcomper]

You my friend are a complete star... Thank you so much....