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.
Yes, that's normal behaviour if you create the rule not from top left cell of the range. Most probably you was on some other cell in column A, if repeat the same from another column that will be transformed to
=IF(XFC1048575=XFC1048576,0,1)