Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting Cell Value Attribution
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting Cell Value Attribution
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--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Brian B" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
How do i put themulti-attribution utility theory (MAUT) worksheet. | Excel Worksheet Functions |