How to display a design in a cell (formula based) to be chosen from either of 3 designed cells

[hsandeep]

1. I have 2 columns with numerical values; say A1 = 130.25 & B1 = 118.68.
2. I have designed 3 arrows (representing UP, DOWN & EQUAL) & have inserted in 3 separate cells, say, R1, S1 & T1.
3. C1=A1-B1 (formula).
4. I want corresponding arrows to be grasped (from either R1, S1 or T1) based on the result in C1 & shown in cell C1. It has to be à If C1=+ve then get R1, -ve get S1, =0 get T1. HOW TO DO THIS?
5. A1 & B1 are DDE feeds & keeps on changing frequently, thus cell C1 should also keep its pace. I am using excel2007.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Thanks in advance. Please do help. Please.
<o> </o>

 

[Peter_SSs]

Peter,
I am trying your earlier suggestion of using conditional formatting.
I will ‘initially’ be happy even if following 3 outcomes results into:
If the cell value is:
Greater than 0 Display Green Light
Equal to 0 Display Yellow Light
Less than 0 Display Red Light
Here I want F to format the cell using CF | Icon Sets | 3 Traffic Lights (Unrimmed).
How to do this?
Secondly, can the cell’s value can be displayed ALONGWITH the above lights ALSO? If yes, please do help.
Sandeep

Sorry, I have been away for a few days.

As I understand what you are asking, all that is certainly possible. Assuming you have removed all previous Conditional Formatting, or started a new test sheet.

1. Select the cells in question (C1:C13 for my sample data above)

2. Home ribbon|Conditional Formatting|Icon Sets|3 TrafficLights (Unrimmed)
(At this point you will have traffic lights in the cells but they are not as you wish, so continue ...)

3. With the cells still selected, Home ribbon|Conditional Formatting|Manage Rules...|select your rule (should be the only one)|Edit Rule...|
next to green light: when value is ... > ... 0 ... Number
next to yellow light: when <= 0 and ... >= ... 0 ... Number
next to red light: should say < 0

4. OK|Apply|OK