View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
K. Trotter K. Trotter is offline
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