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/