Is there a possibility to set up conditional formating based on formulas
connecting files other than the target?

Ex: Highlighting all cells in a column where the value of a given cell is
not represented in a data range in another file?

Thanks,
Ivo