Help amending a macro code to colour change of an amendend cell from its original value

Hi Susan

The way that I would handle this is not to use the worksheet change routine but I would copy the original column to another column (and possible hide it). I would then use conditional formatting so that if the two cells were different, the original cell would be coloured.

Let me know if you need assistance with the conditional formatting.

Regards
Alastair

Thank you for your reply Alastair.

I am so sorry. I am extremely new to excel and wondered if you could advise how i would use conditional formatting to do this?

Hi Susan

No need to apologise - we were all new to Excel once (it's just that for some of us it was a long time ago )

I now have to apologise, as I cannot remember how to do it in Excel 2003 (well, as I said - it was a long time ago)

I attach a spreadsheet showing what I mean and how to do it in Excel 2010. I seem to remember that there was a big change between the versions.

I am now off to sunnier climes for a couple of weeks and will not be allowed on the forum, so if you cannot work out how to do the conditional formatting, I am sure someone will help.

Regards
Alastair