Using Excel 2000
Hi,
I want a Formula or may be VBA to "highlight the reverse patterns", look through column C & highlight if found reverse pattern in column D.
For examples
C10 is 1|X & D10 has X|1
C12 is 1|1 & D12 has 1|1
C14 is X|1 & D14 has 1|X
C15 is 1|2 & D15 has 2|1 and so on...