Jun 03 2021 05:57 AM
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.
Jun 03 2021 08:46 AM
I guess you need to unlock columns and use
=VLOOKUP(CONCATENATE(AE3,AF3),Legend!$C$2:$D$38,2,FALSE)="G"
Jun 03 2021 08:58 AM
Unfortunately when I do this and take out the locking key $, the conditional formatting does not work.
Please see attached.