how do i write a macro to change font color with live data?
 

I have a live data feed into an excel spread sheet and want to be able to
change the color of the font when value of cells change either positive or
negative. E.x., red when it goes down and is negative and green when value
goes up? And suggestions would help greatly

how do i write a macro to change font color with live data?
 

Does the live data feed trigger the Change event. Then I would use that to
store the old value of the cell in a static variable and color the cell
appropriately.

--
Regards,
Tom Ogilvy


"CJS" wrote:

I have a live data feed into an excel spread sheet and want to be able to
change the color of the font when value of cells change either positive or
negative. E.x., red when it goes down and is negative and green when value
goes up? And suggestions would help greatly