I need a formula to use in Conditional Formatting to show what rows have matching data in columns E, H, I, J, K, and N, ex: E2=E3, but I only want the criteria highlighted if all columns, E,H,I,J, K, and N all having matching data, E2=E3 and H2=H3 etc.
See attached WB. Looking at the WB, I would only want row sections 2 and 3, 3 and 4, and 11 and 12 to highlight. I tried to use the formula =AND(E2=E3,H2=H3,I2=I3,J2=J3,K2=K3,N2=N3) but its just not right..
Bookmarks