Conditional formatting - Traffic light system

G

Guest

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(B2>A2,"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
 
B

Bob Phillips

How about Windings with p and q?

--
HTH

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top