View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TheRook TheRook is offline
external usenet poster
 
Posts: 57
Default 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