Hi,
I have created some conditional formatting for certain columns in my worksheet which apply to all rows, i.e. Applies to=$A:$A
But, whenever I copy and paste a new row, additional rules will be created automatically in my conditional formatting and the "Applies to" will be messed up.
Tried the "Protect sheet" + Format cells>Protection>uncheck Locked, but unable to achieve my objective.
Please help.
Thanks.
Bookmarks