Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stoplight indicators in Excel
How does one build stoplight indicators in Excel using the available
technology? -- Best regards! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stoplight indicators in Excel
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
|
|||
|
|||
Stoplight indicators in Excel
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
|
|||
|
|||
Stoplight indicators in Excel
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
|
|||
|
|||
Stoplight indicators in Excel
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 | |
|
|
Similar Threads | ||||
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) |