Create Trend Cell by watching a dynamically updated RTD cell

[tdp3290]

First... my GROVELING: (If youd rather just see problem, look below)
Hi everyone,
I have dropped by this forum on several occasions in the past when I have pretty much pulled out my hair with tyrying to solve a problem with excel. In this case I've searched far and wide including purchasing several books etc from MrExcel...still no luck...

So PLEASE ..if anyone has a tidbit of insight ...I would truly appreciate it...

T~~~
===============================================================

PROBLEM:
I need to create a cell that updates the up/down value of another cell and creates an indicator (Green/Red Up Arrow/Down Arrow etc). Imagine a stock trend indicator which watches a single cell dynamically updating by being linked to an RTD Server of some sort) So in real terms Cell A1 is constantly updating either by RTD link or even manually being changed. Cell B1 looks at the value Cell A1 and puts an indicator in the cell if the value of cell A1 changes to either higher value(up indicator) or lower value(down indication) AND each time the A1 changes it places ANOTHER indicator into the SAME B1 cell BUT does NOT erase the first indicator but places it to the right of the first indicator and LEAVES the original indicator intact..... and continues doing this for x number of iterations...probably 8.

Thanks in advance!!

 

[iyyi]

You can do it with an Event Macro.

Private Sub Worksheet_Change(ByVal Target As Range)
x = 8
If Target.Column <> 1 Or Target.Count > 1 Or Len(Target) > x * 2 Then Exit Sub
If Target.Value > 0 Then Target.Offset(0, 1) = Target.Offset(0, 1) & " " & "G"
If Target.Value < 0 Then Target.Offset(0, 1) = Target.Offset(0, 1) & " " & "H"
If Target.Value = 0 Then Target.Offset(0, 1) = Target.Offset(0, 1) & " " & "F"
End Sub

The Macro will add the the graphic indicator according to the changes in column A.
Format column B with Wingdings Font