Thread: How can I apply conditional formating for cells in different file.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default 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 With QuoteReply With Quote