If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional formating
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 |
#2
|
|||
|
|||
Conditional formating
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 |
#3
|
|||
|
|||
Conditional formating
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 |
#4
|
|||
|
|||
Conditional formating
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formating using formulas | arifnj | Worksheet Functions | 4 | October 27th, 2005 01:56 PM |
VLOOKUP & Conditional Formating Help. | Excel'ed Failures | General Discussion | 6 | August 16th, 2005 04:46 PM |
Conditional Formating in Report Header | Haas | Setting Up & Running Reports | 1 | July 21st, 2004 10:50 PM |
conditional formating | amit | Worksheet Functions | 2 | March 2nd, 2004 03:02 PM |
Conditional Formating | Brw | Worksheet Functions | 3 | December 9th, 2003 03:12 PM |