Formatting cell colour dependant on result...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have in a worksheet a list of user groups... each one with a number - and which sport they play. Each sport is then listed with a colour beside it

On a different work sheet I call a number and using lookup it shows the corresponding User Group. What I need is for the cell that shows the User Group to be in the colour of the Sport they use. Is this possible?
 
There are over 200+ user groups - however there are only 4 different sports that colours are required for (so only 4 colours used).
 
Hi
then use conditional format (you have 3 conditions plus the default
color. So this should work for you)
 
Back
Top