How do I keep Conditional Formatting formulas and ranges from automatically changing?
Posted
by
Iszi
on Super User
See other posts from Super User
or by Iszi
Published on 2013-09-20T18:47:31Z
Indexed on
2014/08/20
16:25 UTC
Read the original article
Hit count: 339
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?
© Super User or respective owner