How do I keep Conditional Formatting formulas and ranges from automatically changing?
- by Iszi
I've found that Conditional Formatting formulas and ranges will automatically adjust when you copy, delete, or move data around in a spreadsheet. While this is a nice idea, it tends to break things for me in some rather weird ways.
To avoid this, I tried writing rules that applied to the entire spreadsheet and keyed off of column headers to highlight the data I wanted to check.
Example: =AND(A$1="Check This Column For Blanks),ISBLANK(A1)) applied to =$1:$1048576
However, even with the rule explicitly applied to the entire sheet, it was still automatically adjusting (and breaking in weird ways by doing so) as I worked in the sheet.
How can I avoid this?
