Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
traffic light in excel | Excel Discussion (Misc queries) | |||
Conditional Formatting Traffic Light System | Excel Worksheet Functions | |||
traffic light formula | Excel Discussion (Misc queries) | |||
Traffic light problem | Charts and Charting in Excel | |||
Traffic Light Filter On Dates | Excel Discussion (Misc queries) |