Lock conditionnal formating ranges
If people copy/paste cells with conditionnal formating, the start range for apply formating change.
You must look for the cells without formating, or re-create the formating range.
Thomas Widmer commented
This would be really great because I could use it fix my biggest excel peeve: E.g. I have a format on Column =$A:$A, when I paste some Data I suddenly have =$A$1:$A$148;$A$150:$A$1048576 even though I want to keep =$A:$A.
Kenneth Barber commented
Can you be more specific?