Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell formating..........
Hi,i don't think this can be done,but if you can prove me wrong i would be
gratefull.....If i have a cell say A1 which is linked to another cell which has a DDE link to another program,this is to do with share price data,what i want is ,if the number in cell A1 is 100 and then changes to say 101,because the new number is higher than the original (100),is it possible for the new number to be blue in colour and if the new number is say 99 ie less than the original to be red?...Im sure you will know what i mean from the way you see share price programs work on television,say on Bloomberg for example....... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell formating..........
On 5 May, 19:16, sonicscooter
wrote: Hi,i don't think this can be done,but if you can prove me wrong i would be gratefull.....If i have a cell say A1 which is linked to another cell which has a DDE link to another program,this is to do with share price data,what i want is ,if the number in cell A1 is 100 and then changes to say 101,because the new number is higher than the original (100),is it possible for the new number to be blue in colour and if the new number is say 99 ie less than the original to be red?...Im sure you will know what i mean from the way you see share price programs work on television,say on Bloomberg for example....... I don't know about the DDE link to another program bit, but if there is a "refresh DDE link" routine which is coded in VBA, then as part of this refresh: Column A (hidden) stores old values Column B (visible) stores new values 1. Copy Column B to Column A (update the "old values - use copy.... pastespecial...values) 2. Store the new values in Column B (from your link) If you have the conditional formatting of the Column B setup based on comparing Column A vs Column B, it should now show in blue / red depending on your preferences. HTH Andrew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Formating | Excel Worksheet Functions | |||
Cell to follow content AND/OR formating of another cell | Excel Discussion (Misc queries) | |||
cell formating | Excel Worksheet Functions | |||
Cell formating | Excel Discussion (Misc queries) | |||
CELL FORMATING | Excel Discussion (Misc queries) |