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.

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.

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.