View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Assistance Needed with Comparing

Hi
yes: not possible with conditional Format. This would require VBA. e.g.
using an event procedure in file 1 (though your extensions indicated
you have text files. For these macros aren't possible)

--
Regards
Frank Kabel
Frankfurt, Germany


Even if using the following logic:

If cell D63 in File 1.txt = Cell AO9 in file 2.txt then nothing, if
doesn't equal then turn cell red.


---
Message posted from http://www.ExcelForum.com/