Problem copying Conditional formatting formula down a column

[mhlester]

Hi, all,

I am having a problem copying a conditional format with a formula down a column of 100 rows.

Here is my formula: =AND(U2="03109",C2&"-"&D2<>VLOOKUP($AA$1:$AA$50,1,0))
My object is to find inconsistent data in each row and highlight the cell in column "U."

The cell references will change only if I copy the conditional format down one row at a time.
If I copy down 6 rows, for example, from row 2, only row 3 formula changes.
The other rows look just like row 3.

ROW2 Formula: =AND(U2="03109",C2&"-"&D2<>VLOOKUP($AA$1:$AA$50,1,0)) Applies to =$L$2
ROW3 Formula: =AND(U3="03109",C3&"-"&D3<>VLOOKUP($AA$1:$AA$50,1,0)) Applies to =$L$3:$L$6
ROW4 Formula: =AND(U3="03109",C3&"-"&D3<>VLOOKUP($AA$1:$AA$50,1,0)) Applies to =$L$3:$L$6
etc.

I would appreciate your help,

Thanks
Michael

[mhlester]

Evidently, the formula works even though it looks wrong.
I found this in a similar post.

... it is weird. I paid so much attention to the 'code under the hood' I didn't notice that the engine worked, even though it looks like it shouldn't!