I have a sheet that highlights cells based on conditional formatting. There is a portion of the data that I have to copy into another sheet and I want it to look the same way. I end up removing some data in the new sheet which also removes the highlights that were in place from the conditional formatting.
Because the sheet I am copying from already looks exactly the way I want, I'm wondering if there is a way I can paste it into the new sheet so it maintains the highlighting the way it is (but not b/c of conditional formatting). Pasting formats won't work b/c that includes the conditional formatting as well. Anyone have any ideas?
Bookmarks