Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
traffic light in excel Lumar Excel Discussion (Misc queries) 4 January 21st 10 03:02 AM
Conditional Formatting Traffic Light System Custard Tart Excel Worksheet Functions 3 July 8th 09 02:03 PM
traffic light formula Vikki Excel Discussion (Misc queries) 3 May 21st 09 03:34 PM
Traffic light problem jackrobyn1 Charts and Charting in Excel 3 June 28th 08 12:32 PM
Traffic Light Filter On Dates JPG Excel Discussion (Misc queries) 3 April 17th 06 12:32 AM


All times are GMT +1. The time now is 09:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"