Why does conditional formatting not work when I copy and paste?
How to copy and paste without messing up conditional formatting You have to make sure that you copy a cell but only paste the conditional formatting rules in that cell (and not everything else such as the value or the…