Post your file.
Don Guillett
SalesAid Software
dguille...@gmail.com
-----Original Message-----
From: ajjw123
Sent: Friday, November 04, 2011 1:05 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ conditional formatting for real time stock
quotes
thanks for the reply .The data is linked to a application which
automatically paste data in sheet1 of the workbook.And I have to link
the data from sheet1 to another worksheets or workbook as i cant
change anything in sheet1.
On Nov 3, 8:36 pm, Sam Mathai Chacko <samde...@gmail.com> wrote:
Here's a simulated refresh to give you the idea of how it can be done.
Now,
my trigger is the click of a button. But in your case, it could be the
query refresh.
Regards
Sam
On Thu, Nov 3, 2011 at 8:23 PM, Sam Mathai Chacko
<samde...@gmail.com>wrote:
> For that you'll have to first tell how your sheet gets refreshed? Is it
> linked to a web query? Normally, you'd want to save the existing values
> in
> a second sheet, and make the conditional comparison based on the current
> value.
> Regards,
> Sam
> On Thu, Nov 3, 2011 at 8:20 PM, ajjw123 <ajjw...@gmail.com> wrote:
>> i have a excel sheet in which real time stock quotes gets updated
>> automatically every second.
>> I would like to highlight the value as red if the new stock quote is
>> greater than the previous one.
>> And highlight the quote as blue if the new stock quote is lesser than
>> the previous one.
>> thanks.
>> --
>> FORUM RULES (925+ members already BANNED for violation)
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Cross-promotion of, or links to, forums competitive to this forum
>> in
>> signatures are prohibited.
>> NOTE : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
------------------------------------------------------------------------------------------------------
>> To post to this group, send email to excel-macros@googlegroups.com
> --
> Sam Mathai Chacko
--
Sam Mathai Chacko
Live Change Track.xlsm
25KViewDownload
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
