Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How does one build stoplight indicators in Excel using the available
technology? -- Best regards! |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Trotter,
Can you be more specific? Thanks Alok Joshi "K. Trotter" wrote: How does one build stoplight indicators in Excel using the available technology? -- Best regards! |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am putting together some dashboard reporting for some projects that I am
facillitationg and also for month end reporting. I want to be able to build stop light indicators that would (based on the criteria that I would set) show whether a metric that we are tracking is either Better (Green) Regressing slightly (Yellow) or 10% worse (Red) than the following months numbers. The same goes for projects. Green if it's on time, yellow if it is 1 day to 1 week behind, and Red if further behind than that. I hope this helps and I thank you for any assistance you can provide! -- Best regards! "Alok" wrote: Trotter, Can you be more specific? Thanks Alok Joshi "K. Trotter" wrote: How does one build stoplight indicators in Excel using the available technology? -- Best regards! |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#6
![]()
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 |
#7
![]() |
|||
|
|||
![]() Quote:
https://excelkid.com/traffic-light/ |
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) |