| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Event Macro adjustment needed - need to change font color also | Excel Worksheet Functions | |||
| Macro to Change Font Color | Excel Programming | |||
| Excel 2000 = upgraded to 2003 and macro to change font color fail | Excel Programming | |||
| Excel Macro to change row and font color based on column value | Excel Programming | |||
| change font color of first cell in data table attached to chart | Charts and Charting in Excel | |||
Linear Mode
