Forum Discussion
Keep conditional formatting range when inserting/deleting cells/rows/columns?
Was having the same issue and so my search led to this forum, searched everywhere else and couldn't find the answer, played around with it and finally figured it out. It's actually a pretty simple solution.
Instead of Inserting a column or copying and inserting a column, all you have to do is select the column cells that you want to extend, then at the bottom of the cursor where the plus sign is, click and drag to the right as many columns as needed.
The CF range extended to the last column without creating any extra conditions or messing up the original range.
I believe I had the same problem, I have large sheet with conditional formatting across the whole sheet, so if a value in Column C was "XXX" then the whole row would grey out. I then decided to insert some columns from another spreadsheet into Columns EFG. The problem was the data I was inserting was unique whereas the spreadsheet contained duplicates (long story but I am reconciling different data sources to create a golden source so I need the wrong stuff too). Anyways.... When I tried to insert cells across EFG to push my inserted data down because there was a dupe on a row, all the CF went with it. So now my XXX grey CF was broken. Which surprised me as as CF rarely moves and my sheet had a CF applied $A$1:$CC$9999 so what to do? My work around was lots of copy and pastes to pick up EFG from where it was and paste it below and then go back and delete the data in the row above. It was manual but took half an hour.