Icon Sets Conditional Formatting in Excel 2007

[peedub]

So, I want to be able to use the Icon Sets in conditional formatting
with text values. I bet there are a bunch of other people out there
that would like to have the text "green", "yellow" or "red" converted
to the appropriate stoplight icon, but I cannot figure out how to make
this work. Is it possible?

 

[Herbert Seidenberg]

Excel 2007
Icons
Maybe not quite what you wanted...
http://www.mediafire.com/file/dytjrggnxbm/09_26_09.xlsx

 

[peedub]

Excel 2007
Icons
Maybe not quite what you wanted...http://www.mediafire.com/file/dytjrggnxbm/09_26_09.xlsx

That's pretty slick, Herbert, but I don't get it. How is it you have a
numeric value in the cell, but it shows with the stoplight icon and
text?

 

[peedub]

So, I want to be able to use the Icon Sets in conditional formatting
with text values. I bet there are a bunch of other people out there
that would like to have the text "green", "yellow" or "red" converted
to the appropriate stoplight icon, but I cannot figure out how to make
this work. Is it possible?

Sorry - I forgot to specify that I am using Excel 2K7. If OS matters,
it's on Vista.

 

[panndxb]

Excel 2007
Icons
Maybe not quite what you wanted...
http://www.mediafire.com/file/dytjrggnxbm/09_26_09.xlsx

Hi Herbert. This solution is excellent. But i could not interpret how is it working. Could you please explain. I want to use the same but with different text. High, Medium, Low

Thanks,
Panneer