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

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!

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!

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!

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

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

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