Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
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

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 03:16 PM
Stoplight symbols in excel moosiecuti Excel Discussion (Misc queries) 1 November 21st 06 08: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 08:51 AM.

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

About Us

"It's about Microsoft Excel"