Conditional formating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ivo Toomla - 03 Nov 2005 15:20 GMT

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

Reply to this Message

Bob Phillips - 03 Nov 2005 18:08 GMT

Conditional formatting can work on a separate workbook.

Signature

HTH

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

> Is there a possibility to set up conditional formating based on formulas
> connecting files other than the target?
[quoted text clipped - 4 lines]
> Thanks,
> Ivo

Reply to this Message

Ivo Toomla - 04 Nov 2005 09:31 GMT

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.

......

> Conditional formatting can work on a separate workbook.
> > Is there a possibility to set up conditional formating based on formulas
[quoted text clipped - 5 lines]
> > Thanks,
> > Ivo

Reply to this Message

Bob Phillips - 04 Nov 2005 09:55 GMT

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.

Signature

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:
[quoted text clipped - 13 lines]
> > > Thanks,
> > > Ivo

Reply to this Message