My can should have been can't sorry.

You can use CF to reference another sheet as long as you assign an Excel
Name to the range on that other sheet (InsertNameDefine), and use that
name in the CF formula.

--

HTH

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


"Ivo Toomla" wrote in message
...
All attempts to use conditional formating with references outside the
sheet
bring up a message:

You may not use references to other worksheets or workbooks for
Conditional
Formatting criteria.

......

"Bob Phillips" wrote:

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