Forum

Notifications
Clear all

Link text to colour code (traffice light)

3 Posts
2 Users
0 Reactions
144 Views
(@melanpaes)
Posts: 10
Active Member
Topic starter
 

Hi Excel Geeks

I am trying to link the text entered in one column to the colour code in another column.  Is there are a quick and easy way of doing this  - please see attached the file.

I would appreciate your help on this issue.

 

Regards

Mel

 
Posted : 22/10/2016 3:45 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi mel

See if this is what you are looking for. I have included 2 conditional formatting examples.

Sunny

 
Posted : 22/10/2016 4:30 am
(@melanpaes)
Posts: 10
Active Member
Topic starter
 

Hi Sunny

Thanks for the two conditional formatting options that is really great.

Once again thank you!

 

Regards

Mel

 
Posted : 22/10/2016 3:29 pm
Share: