1 min readfrom 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.

submitted by /u/wishful_thonking
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#row zero
#Excel alternatives for data analysis
#Excel compatibility
#generative AI for data analysis
#rows.com
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#conditional formatting
#Excel
#pasting values
#formatting rule
#range
#borders
#copy
#cut
#cell
#row