Hi

I have a question regarding vlookup's

I want to vlookup one workbook to another so that when value changes in workbook 1 it also changes in workbook 2. However I also need to highlight the cell in workbook 2 to show that it has changed.

I am struggling to see how I could get this to work, any help would be greatly appreciated.

Regards

mrchops