Forum Discussion
Pasting new data into a table, without deleting conditional formatting
Hello, I'm wondering if there is a way to avoid having to paste values when adding data to my worksheet/table, as just a simple ctrl v is removing the conditional formatting from my sheet for those...
If you are using Excel for the web, maybe you can try using the Paste Options feature to paste only the values without removing the conditional formatting. See the upper link.
Haven't tried it myself, should actually work with All merging conditional formats (Pastes the contents and conditional formatting options from the copied cells).