•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Is it possible to prevent conditional formatting ranges from breaking when you copy/cut data to and from the range?
I currently have a conditional formatting rule set up for range $1:$1. However, this will break (and subsequently cause a lot of lag) if I copy a cell from a different row and paste it into row 1, or cut a cell from row 1 and paste it to a different row. I'm aware this is because I'm pasting the formatting and that's overriding the rule. Is there a way to make Excel not do that?
I'm aware of pasting values not breaking the formatting; however sometimes there are things like borders which I want to copy over without having to mirror the formatting manually.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com