Cope and Paste- Cell Color Change

BESP10

Good afternoon,

Our sheet is now changing cell colors when we copy and paste in it. Why did this happen and how do we make this stop doing this?

Paul Newcome

It may be that there was some manual formatting applied to that top row that isn't visible because of the conditional formatting.

Highlight that entire row and change the cell fill to white. You should not see an immediate difference as the Conditional formatting will still fill those cells with red, but the copy/paste should leave the cell fill alone from there on.

Paul Newcome

It may be that there was some manual formatting applied to that top row that isn't visible because of the conditional formatting.

Highlight that entire row and change the cell fill to white. You should not see an immediate difference as the Conditional formatting will still fill those cells with red, but the copy/paste should leave the cell fill alone from there on.

BESP10

HA

That worked thanks @Paul Newcome

Paul Newcome

Happy to help. 👍️