So I'm working on a project where I have a blank sheet which is conditionally formatted so that when information is copied in, it changes colors depending on the value input. When I put in the raw data though, all the conditionally formatted columns realign to what the raw data's columns width were.

So my question is, is there a way to make it so that someone can copy paste data from the raw data worksheet into the formatted worksheet without disrupting the formatted cell size?

Thanks!