Conditional Formatting applying to old columns when new columns are copied and inserted.

[milo1234]

I have columns that have conditional formatting applied using a CONCATENATE formula. 

When I copy and paste the new columns, the formula still uses the old columns and doesn't pick up the new ones. Please can someone help? I have attached a sample file. 

For example, columns AK & AL are picking up columns AN & AO when I copy the three columns. 

[#2]

@milo1234 

I guess you need to unlock columns and use

=VLOOKUP(CONCATENATE(AE3,AF3),Legend!$C$2:$D$38,2,FALSE)="G"

[#3]

@Sergei Baklan 

Unfortunately when I do this and take out the locking key $, the conditional formatting does not work. 

Please see attached.

[#4]

@Sergei Baklan