Conditional formating

[Ivo Toomla]

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

 

[Bob Phillips]

Conditional formatting can work on a separate workbook.
--

HTH

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

 

[Ivo Toomla]

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]

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 (Insert>Name>Define), and use that
name in the CF formula.

--

HTH

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