Cell color change if value is = or > or < compare with previous cell

[cityguy10005]

In my spread sheet attached, Cell A1 is linked with another application and updates value very frequently.
.
Macro attached automatically copies Cell A1 value and paste into next available empty cell every 5 seconds.
.
What I need to change cell color every time if cell value is = or > or < then previous cell.
.
If next cell value is > then previous cell then color should be Blue
If next cell value is < then previous cell then color should be Red
If next cell value is = to previous cell then color should be Yellow
.
Please see code I am using in macro:
.

Please Login or Register  to view this content.

Any help will be appreciated.
.
Regards,

[xladept]

Hi Cityguy100005,

Try this in the Worksheet:

Please Login or Register  to view this content.

[cityguy10005]

Hi xladept,

thanks for your reply. I tried but seems like i am doing wrong. I am totally new to macros, Would you please kind enough to tell me where i have to place these code?

i am using full macro code as below:
.

Please Login or Register  to view this content.

.
Regards,

[Cutter]

@ cityguy10005

Please notice that code tags have been added to your post(s). Having been a member for over 3 years you should be aware that the forum rules require them so please add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

[xladept]

Hi Cityguy10005,

You place that code right in the Worksheet where it will be used - in the visual basic editor there is a list of the the Worksheets followed by the Workbook itself - click on your Worksheet where this will happen and paste the code in the Worksheet module - not the standard module that you've shown in your post.

Here's a copy of your book with the code in the correct place:CityGuy100005.xls

[cityguy10005]

hi xladept,
.
Works perfect. Appreciate it.
.
what do i have to change if i want to include multiple culumns.
First row of all the columns are same like A1.
.
Best regards,

[xladept]

Hi Cityguy100005,

If you want specific columns just change this line:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

or if they're all to get that treatment remove:

Please Login or Register  to view this content.

and one of the "End If"'s at the end.

[cityguy10005]

xladept,
.
thats perfect. thanks for your time and help.
.
best regards,

[xladept]

You're welcome!