Thread: How can I apply conditional formating for cells in different file.
View Single Post
  #2   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.
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.
Reply With QuoteReply With Quote