This is a problem that Microsoft Excel has had for decades, and it is a problem that should not exist. The user who posted this is describing a workflow that any regular spreadsheet user will recognize: they set a conditional formatting rule for an entire row, and then they copy or move a cell in a way that overwrites that rule. The result is a broken format, a laggy file, and a frustrating hunt for the original rule. The proposed workaround, pasting only values, fails because they also need to bring over borders or other formatting from the source cell. They are stuck between two bad options.
Our opinion is clear: this is a design limitation, not a user error. The user is doing something entirely reasonable. They want to move data while keeping the visual structure of their spreadsheet intact. Conditional formatting is supposed to be the tool that handles that automatically. Instead, it gets erased the moment a single paste operation touches the target range. The system treats formatting as a property of the cell, not a rule applied to the range. That distinction is invisible to most users until it breaks their work. The result is that a feature meant to save time actually costs time, because the user now has to rebuild or reapply rules that should have been preserved.
What this means in practical terms is that anyone managing moderate-to-complex spreadsheets is living with a hidden tax on their productivity. Every time you copy a cell into a conditional-formatting range, you are gambling that the paste will not overwrite the rule. If it does, you lose not just the formatting but the logic behind it. You then have to remember what the rule was, find it in the conditional formatting manager, and reapply it. And if the rule was part of a larger system of interdependent rules, the cascade of broken formatting can take minutes or hours to fix. The user mentions lag. That lag is not from the data; it is from the spreadsheet engine trying to reconcile broken rules with every recalculation.
The solution is not for users to memorize a dozen paste-special shortcuts. The solution is for spreadsheet software to treat conditional formatting as a first-class property that survives data movement. Excel has had years to address this. It has chosen not to. For anyone still using traditional spreadsheets, the practical advice remains the same: use paste-special with values and manually reapply borders, or accept that moving data will sometimes break your rules. Neither is acceptable for a tool that claims to support modern data work. The only real fix is to move to a system where conditional formatting is attached to the rule, not the cell, so that pasting data never destroys the logic that makes your spreadsheet useful.