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/