Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
All of the responses that I have received have been most helpful! Thank you
for your time and asistance! -- Best regards! "Ron Coderre" wrote: Is use this fairly simple way to show stoplight indicators: 1)Set a custom number format for the indicator cells: FormatCellsNumber Tab Category: Custom Type: "l";"l";"l" (that's lower case L's in quotes) 2)Set the font for Wingdings A lower case L in Wingdings font displays a solid circle. 3)Set up conditional formatting for to change the font color for each status you want to display. (eg Red for <.2, Yellow for .2 to .7, Green for over .7) That works for me....Can it work for you? -- Regards, Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional format stoplight based on worst color | Excel Worksheet Functions | |||
How do I set up a stoplight chart in excel to show % training com | Excel Discussion (Misc queries) | |||
Stoplight | Excel Discussion (Misc queries) | |||
Stoplight symbols in excel | Excel Discussion (Misc queries) | |||
Stoplight symbols in cells | Excel Discussion (Misc queries) |