Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 6th 05, 01:27 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2005
Posts: 3
Default Stoplight indicators in Excel

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

  #2   Report Post  
Old May 6th 05, 01:51 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 318
Default 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   Report Post  
Old May 7th 05, 09:04 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2005
Posts: 3
Default 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   Report Post  
Old May 8th 05, 12:12 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2005
Posts: 91
Default 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   Report Post  
Old May 8th 05, 07:06 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2005
Posts: 3
Default 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   Report Post  
Old June 12th 21, 02:16 PM
Junior Member
 
First recorded activity by ExcelBanter: Jun 2021
Posts: 2
Default

Quote:
Originally Posted by K. Trotter View Post
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/


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional format stoplight based on worst color Morgimo Excel Worksheet Functions 3 July 21st 09 11:28 PM
How do I set up a stoplight chart in excel to show % training com paul mauro Excel Discussion (Misc queries) 1 October 7th 08 01:13 AM
Stoplight CB Excel Discussion (Misc queries) 4 January 10th 07 04:16 PM
Stoplight symbols in excel moosiecuti Excel Discussion (Misc queries) 1 November 21st 06 09:03 PM
Stoplight symbols in cells wacNTN Excel Discussion (Misc queries) 2 September 28th 06 10:44 PM


All times are GMT +1. The time now is 10:14 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017