Hello,
I am trying to use conditional formatting to detect when two cells have different values. The formula is quite simple: =G50 <> G58 . I want Cell G58 to become red when its value doesn't match with that in G50.
The problem is the Cell G58 is always showing red, except when I enter the...