I have a spreadsheet with conditional formatting and cell formulas on it (A). I have a backup of (A) on a second sheet (B) that also contains the same conditional formatting and cell formulas. At the end of the day instead of clearing the data on (A) I replace sheet (A) with sheet (B) by a sheet copy and paste macro. I do this to eliminate and possible of someone accidently modifying or deleting cell formulas for formatting on (A).
Now my problem, I have noticed that the conditional formatting on sheet (A) is not being replaced by the conditional formatting of sheet (B) during the copy and paste. Instead sheet (A) is adding the formatting thus replicating the conditional formatting commands during each paste. Sheet (A) continues to work fine but sooner or later this ever growing conditional formatting section will fail.
I have tried un formatting (B) but when I paste over (A) it leaves no formatting as all.
So how can I sheet paste (B) over (A) keep cell formulas and also only have one (Set) of Conditional formatting rules?
Now my problem, I have noticed that the conditional formatting on sheet (A) is not being replaced by the conditional formatting of sheet (B) during the copy and paste. Instead sheet (A) is adding the formatting thus replicating the conditional formatting commands during each paste. Sheet (A) continues to work fine but sooner or later this ever growing conditional formatting section will fail.
I have tried un formatting (B) but when I paste over (A) it leaves no formatting as all.
So how can I sheet paste (B) over (A) keep cell formulas and also only have one (Set) of Conditional formatting rules?