Conditional formatting - Traffic light system
 

I currenly have a traffic light system set up using conditional formatting
and wingding fonts, which works just fine.

What I am wanting to do now is if we beat a spacific target a Green bold
upwards pointing arrow is display and if we dont then a read bold downwards
arrow is displayed.

I thought this woul be simple by just using =IF(B2A2,"a","b") the "a" would
be the arrow up, b the arrow down and the cell would have a font where the
displays the arrows.

Unfortunately I have been unable to find a font where a letter = and arrow,
I can only find symbols that are entered by holding alt and then entering a 3
digit number.

Is there any other way I can do this?

Regards

Conditional formatting - Traffic light system
 

How about Windings with p and q?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"TheRook" wrote in message
...
I currenly have a traffic light system set up using conditional formatting
and wingding fonts, which works just fine.

What I am wanting to do now is if we beat a spacific target a Green bold
upwards pointing arrow is display and if we dont then a read bold
downwards
arrow is displayed.

I thought this woul be simple by just using =IF(B2A2,"a","b") the "a"
would
be the arrow up, b the arrow down and the cell would have a font where the
displays the arrows.

Unfortunately I have been unable to find a font where a letter = and
arrow,
I can only find symbols that are entered by holding alt and then entering
a 3
digit number.

Is there any other way I can do this?

Regards