How can I apply conditional formating for cells in different file.

  • Thread starter Thread starter Hassan
  • Start date Start date
H

Hassan

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