Forum Discussion
Solved
Conditional Formatting Formula Changes Erratically
I am trying to format a cell if it is not equal to another cell, but the formula I type in changes itself. Here is what I did, starting with a blank sheet. typed x into A1 typed y into A2 clicked...
Forgot to say, it's when changing the range we move reference in the formula out of the sheet. If modify my pervious example, start the rule from cell A17 with formula =A11>2 and after that apply the range to =A11:A15 when reference in the formula will be changed on =A5>2, i.e. on 6 rows up.
your steps seems perfect.
can u share the file, i can check further
can u share the file, i can check further
bhushan_z File is attached, but the issue is more the process than the end result, so to duplicate it you would need to follow the steps.
Forgot to say, it's when changing the range we move reference in the formula out of the sheet. If modify my pervious example, start the rule from cell A17 with formula =A11>2 and after that apply the range to =A11:A15 when reference in the formula will be changed on =A5>2, i.e. on 6 rows up.
- Thanks for the explanation.
I understand that it is reproducible, and I understand that changing the reference causes the cell in the formula to move off the sheet.
I disagree that this is "expected behavior". I would have expected the formula I entered to stay the same, or at least some sort of warning that is has been changed automatically. 🙂
I have another question about conditional formatting, but I will post it separately for clarity.
Thanks!
