| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I apply conditional formating for cells in different file.
I would like to set-up a conditionl formatig that will compare 2 cells in
different files. Currently I am getting the error message telling me that contitional formationg can not be done for cells in different sheets or file. Help is appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I apply conditional formating for cells in different file.
You can use INDIRECT to get the CF to work across sheets, eg:
=ISNUMBER(MATCH($A1,INDIRECT("'Sheet2'!A:A"),0)) -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Hassan" wrote: I would like to set-up a conditionl formatig that will compare 2 cells in different files. Currently I am getting the error message telling me that contitional formationg can not be done for cells in different sheets or file. Help is appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I apply conditional formating for cells in different file.
To work across files, the source book must be simultaneously open,
and the CF formula will look like this in the destination book's sheet eg: =ISNUMBER(MATCH($A1,INDIRECT("'[Book2.xls]Sheet2'!A:A"),0)) -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Hassan" wrote: I would like to set-up a conditionl formatig that will compare 2 cells in different files. Currently I am getting the error message telling me that contitional formationg can not be done for cells in different sheets or file. Help is appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Apply Conditional formating to all cell | Excel Worksheet Functions | |||
| Apply conditional formatting to cells formatted as percentages? | New Users to Excel | |||
| How to apply conditional formatting on group of cells by using dat | Excel Discussion (Misc queries) | |||
| conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
| Is it possible to apply conditional formating to a pivot chart? | Charts and Charting in Excel | |||
Linear Mode
