Change Color Cell only when updating the link of the current workbook

[sirbudan82]

I have a consolidation file linked to 35 other files and I would like to not worry every time I'm updating the links. I would like to have let's say the red color for all the values from the consolidation file and the color to change to green when I'm updating the link for one of the 35 files.

I tried with conditional formatting but I didn't find the magic formula yet.