PC Review


Reply
Thread Tools Rate Thread

Conditional formatting - Traffic light system

 
 
=?Utf-8?B?VGhlUm9vaw==?=
Guest
Posts: n/a
 
      7th Oct 2006
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
 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      7th Oct 2006
How about Windings with p and q?

--
HTH

Bob Phillips

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

"TheRook" <(E-Mail Removed)> wrote in message
news:02074FFC-A5CD-4E38-86F5-(E-Mail Removed)...
> 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



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting using Traffic Lights Ruby Pro Microsoft Excel Misc 6 14th May 2010 12:22 AM
Traffic Light or Stop Light Chart Kerensky18 Microsoft Access Reports 4 10th Aug 2009 08:56 AM
Conditional Formatting Traffic Light System Custard Tart Microsoft Excel Worksheet Functions 3 8th Jul 2009 02:03 PM
Conditional Formatting using 3 Traffic Lights Formula BureFreak Microsoft Excel Worksheet Functions 3 22nd May 2008 07:28 PM
High light cells or conditional formatting jenna Microsoft Excel Programming 5 25th Jan 2004 10:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:54 PM.