Traffic Lights (RAG) Analysis

Here's a way to include RAG analysis within your workbooks

There's no VBA used. It's just plain and simple formatting.

Sample Outputs

To get these effects:

• Change the font in the cells where you want characters, for example: "Wingdings 3"
• Then, from the menu, Format > Cells: Custom

Easier still, just copy and paste from the sample workbook!

The sample workbook also contains listings of characters from the following fonts:

• WebDings
• WingDings
• WingDings 2
• WingDings 3
• DingBats

Demo file: Traffic_Lights.zip

Published: 17-Nov-2005
Last edited: 01-Mar-2011 20:50