Colour a cell background if 'result' is entered by macro

[Tanyab]

Hi All,

I have the following code that compares what is in a column in once sheet (with cetrain criteria) and look for it in another sheet and updates the values of what is says in the other sheet (again if it matches certain criteria. It is working very well, but if it puts a new result in the cell, I would like it to colour the cell green so that the users can see which values have been added. Logic says that the last line is the most important and the code to colour the result cell should go here, but I have tried many ways and it doesnt seem to colour anything!

Please help.

Please Login or Register  to view this content.

[wenqq3]

is this code at new result to the cell?

Please Login or Register  to view this content.

then add another code below it

Please Login or Register  to view this content.

[Tanyab]

Thank you for your help.

I have input the code below so the section in question looks like below;

Please Login or Register  to view this content.

However, I am getting a runtime error 424 'Object required'. Are you able to help?

[wenqq3]

Please Login or Register  to view this content.

Try this.