Conditional formatting Cell Value Attribution

[Brian B]

Hello,
I would like to be able to take advantage of the Stop-sign Conditional
Formatting available in Excel 2007. It turns out, that this Traffic-Light
set (more officially known as Icon Sets) will only correspond to numerical
values, as opposed to a string value.

Therefore, what I would like to do is attribute an arbitrary value, such as
'10', to a specific string value, for example: "Requirement Satisfaction:
Full". Then, '10', will correspond to a Green Traffic light, and therefore
the cell that states "Req Sat. Full" will have that compliance implying icon
next to it. '8' could signify partial compliance (yellow light), and '5'
would mean non-compliance (red light).

Obviously I could easily convert the String into a Number, but then I lose
the significance of the color coding altogether. I would like to 'attribute'
the value to the cell, so that the traffic light shows up, but not display
that value.

Is this possible?

I really am disappointed that I can't apply those traffic light icons to
Strings instead of integers.

Thanks,
Brian

Is there a way this is possible.

 

[ryguy7272]

How about this?
http://www.andypope.info/charts/trafficlight.htm

In Cell A1:
Requirement Satisfaction: Full

In Cell B1:
=IF(A1="Requirement Satisfaction: Full",10,"")

HTH,
Ryan---