Re: conditional formulating
- From: "francis" <francis@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 5 Sep 2005 19:25:02 -0700
Hi Gearoi,
i'm using the spreadsheet to help me to monitor if a page on Reuters is
updating correctly/promptly. right now first I copy the time stamp on the
Reuters page to a cell on Excel. Then on another cell, I will copy another
link from another Reuters page showing the actual time. If the page i'm
monitoring is updating, the conditional formatting on the third cell will be
white in colour. If the page is not updating; the timestamp on that page is
not the same as the actual time on another Reuters page, the third cell with
conditonal formatting will then turn red.
What i want to find out is if there's another more "active" way to monitor
besides going to the spreasheet to view it every now and then.I'm thinking if
the page is not updating for say more than 5 mins, a pop up will appear or a
sound will be heard simliar to what happened when we received a msg in MSN.
Hope the details helps and thanks for replying. hope to hear the good news
from you.
"gearoi" wrote:
>
> use msgbox and it'll pop up if you are running a macro which goes
> through the data.
>
> really need more info to be more help :)
>
>
> --
> gearoi
> ------------------------------------------------------------------------
> gearoi's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26576
> View this thread: http://www.excelforum.com/showthread.php?threadid=401891
>
>
.
- References:
- conditional formulating
- From: francis
- Re: conditional formulating
- From: gearoi
- conditional formulating
- Prev by Date: Trace dependents not working
- Next by Date: Re: Data Validation - still difficult
- Previous by thread: Re: conditional formulating
- Next by thread: Ctrl C
- Index(es):
Relevant Pages
|
