Confitional formatting

[exc1967]

Is there a conditional formatting rule that would allow me to highlight all cells in a row where if the 5th, 6th and 7th characters in column b match the first 3 in column A? So in the example below, it would highlight the 4th one down.


363004 1001201
203003 1067201
204003 1081201
2011N3 1082201
207083 1082201F

[Fluff13]

How about
=LEFT(A2,3)=MID(B2,5,3)

[exc1967]

I have the conditional format for Column B. But it isn't working. I may be doing something incorrect.

[Fluff13]

Not quite sure what's going on, but if you select the cells & change the fill colour to no fill, then the Cf works.