Conditional formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Conditional formatting can work on a separate workbook.
--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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.

.......
 
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)
 
Back
Top