Hi,


I have this problem: with one query-web I load the data of Borsa in real time with updating of 2 minutes (my choice), the macro is activated alone when I Autonomously open the file and then it handles the refresh of the data every 2 minutes.
And until here all OK. Then I have added a column with data of reference to use as I compare relative, therefore statics that is activated by itself at 9,15 o'clock in the morning.
I have also prepared a macro that the comparison does and the cells that he is modified as during the day, a sort of color refresh.

However and do I connect the query refresh of data to this macro? don't I frankly know what to do, ideas suggestions? thanks