Hi there,\
Sorry for my long Title description - hope i got it right !!
Is there a way to look at a cell's own value and then format it accordingly using VB?
eg,
I have a cell whose value changes based on DDE link to live price data.
Cell is "Q5".
When the new value is greater than the old value - i want to format the pattern color of the cell.
When the new value is less than the old value - i want to format the pattern color of the cell.
Does anyone know how to do this please or is there a way to do this using spreadsheet formulas as oppose to VB?
THanks in advance for looking in..
Sorry for my long Title description - hope i got it right !!
Is there a way to look at a cell's own value and then format it accordingly using VB?
eg,
I have a cell whose value changes based on DDE link to live price data.
Cell is "Q5".
When the new value is greater than the old value - i want to format the pattern color of the cell.
When the new value is less than the old value - i want to format the pattern color of the cell.
Does anyone know how to do this please or is there a way to do this using spreadsheet formulas as oppose to VB?
THanks in advance for looking in..