ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Stoplight indicators in Excel (https://www.excelbanter.com/excel-programming/328858-stoplight-indicators-excel.html)

K. Trotter

Stoplight indicators in Excel
 
How does one build stoplight indicators in Excel using the available
technology?
--
Best regards!

Alok

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!


K. Trotter

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!


Nick Hodge

Stoplight indicators in Excel
 
This is in the programming group, but the same applies.

Use the built in functionality of conditional formatting (FormatConditional
formatting...)

Check out here

http://www.nickhodge.co.uk/gui/forma...formatting.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"K. Trotter" wrote in message
...
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!




Ron Coderre[_5_]

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

K. Trotter

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


johnbarrel

Quote:

Originally Posted by K. Trotter (Post 1153609)
How does one build stoplight indicators in Excel using the available
technology?
--
Best regards!

Hi, you can use conditional formatting or apply ready-to-use widgets like this:
https://excelkid.com/traffic-light/


All times are GMT +1. The time now is 04:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com