This question is a clarified subset of Prevent breaking formulas/formatting by moving cells in locked worksheet, which hasn't been solved yet.
Imagine a simple Excel game:
| A | B | ---------- 1 | 19 | | 2 | 5 | | 3 | 23 | | 4 | 8 | |
The user has to go to the cells in
B and retype in the number on the left (I know, stupid, but it's an example!). To make it visible if he/she did it right, there's a conditional formatting:
=$A1<>$B1is true, the text is getting red; applied to
This works, but...
- The player types
B1. It gets red. He/She realizes the mistake and moves the
8to the correct cell with drag&drop.
8stays red and the conditional formatting is split up into
=$A3<>$B3is true, the text is getting red; applied to
=$A1<>$B2is true, the text is getting red; applied to
How can one prevent breaking the formatting when using drag and drop?