t Hey guys, im getting mad about something really simple. Why does this plain conditional formatting light up the values 15 and 12? When applied only for cell D1 or F1 it works properly, I'm really clueless. Thank you for your advice!

Also my greetings got deleted everytime after saving the edit, I had to put a random letter in front so it got through, whats up with that random behaviour lol

CodePudding user response：

instead of your:

=A1

use:

=$A1