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

G

Guest

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Hyperlinks Without Changing background shading 14
Change the font color based on the value of the cell 9
Change the font color based on value of cell 1
Formula needed changing font color 1
fill color to a cell when the value is negative or positi 2
changing the color of a cell acording to its value 4
Excel formula/macro integrating with font colors? 3
Changing font color based on type cell it is. How to do it? 6

Top