Conditional formatting can work on a separate workbook.
--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ivo Toomla" wrote in message
...
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