Conditional Formatting to letters

H-Tech

New member
Joined
Mar 20, 2014
Messages
2
Reaction score
0
Points
0
Hi, people I am looking for a way to give icons to a table of letter. For example is there any way to assign a numeric value to a name and that name with that value assigned in the same cell can take a conditional formatting with the icons sets. I attach a spreadsheet with what I am looking for, in the upper part is what I came up with using vlookup formula but, at the bottom is really the way I am looking to get the table; right know the icons are just image. If there is a way I really will be very thankful.
 

Attachments

  • Icons.xlsx
    18.5 KB · Views: 14

peter.abing

New member
Joined
Oct 24, 2012
Messages
34
Reaction score
0
Points
0
Hi, people I am looking for a way to give icons to a table of letter. For example is there any way to assign a numeric value to a name and that name with that value assigned in the same cell can take a conditional formatting with the icons sets. I attach a spreadsheet with what I am looking for, in the upper part is what I came up with using vlookup formula but, at the bottom is really the way I am looking to get the table; right know the icons are just image. If there is a way I really will be very thankful.
I found this solution: http://www.mrexcel.com/forum/excel-questions/589125-using-icon-sets-excel-2007-text-values.html
 

H-Tech

New member
Joined
Mar 20, 2014
Messages
2
Reaction score
0
Points
0
Thanks Peter I will verified if I can use it
 
Top