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