Thanks for the reply pike, but it doesn't work. Maybe I'm doing something wrong ?

I opened Excel file A, right click on the sheet name, click "view code", and pasted the code there, and saved the file.

Then I open the source file and changed the value. When I opened file A again to update the links to file B, the numbers are updated, but the font doesn't get highlighted to red. Any thoughts on this ?