Excel 2007 scorecard to be viewed in Office XP

**sridhar.voleti** · 06-15-2009, 07:08 AM

Hi All,
I have a scorecard created in excel 2007. All my end users are using excel 2002. Now I want to build a scorecard in Excel 2002 like what we have in excel 2007. Is it possible.
I want to display the traffic signals and 5 level indicators (arrows), based on conditional formatting.
This is out of box in excel 2007. But how do I achieve this in excel 2002?
Is there a simple method? Please suggest...

Thanks in advance
Sri

**Andy Pope** · 06-15-2009, 07:10 AM

A lot depends on the complexity of the conditions.

You maybe able to use webdings, or similar, font and conditional formatting.
Or shapes and VBA code.

http://www.andypope.info/tips/tip011.htm

**sridhar.voleti** · 06-15-2009, 07:40 AM

Hi Andy,
Thanks for your response. Now in excel 2007, we have an arrow which represent silghtly off target (the angular down arrow) and slightly ahead of target (the angular up arrow). Do we have the same in Wingdings font? And what about the traffic signals (red, amber, green)? Do we have an oval representing them?
Thanks again
Sri

**Andy Pope** · 06-15-2009, 07:48 AM

Use the Character map application in Windows to see what characters are available for any given font.

These are all the arrows for wingdings
çèéêëìíî

for oval in traffic light you can use
l

**sridhar.voleti** · 06-15-2009, 08:39 AM

Thanks a lot. I think this will do

Regards
Sri

**sridhar.voleti** · 06-17-2009, 02:40 AM

Hi Andy,
As suggested , i have tried using the wingdings font. I am not facing any issues with arrows. But when I use the oval and give three conditions in conditional formatting, I can see that it is not working properly, means when I give green and amber for the first two conditions, it is working fine, but when I add the third condition red -> it is not working ie, the green and amber still work but red is not working.
Any siggestions?