Hello Dear community,
I am trying to use conditional formatting to highlight cells. if cell and next cell's sum is not =1
I tried =(BQ2+BR2)<>1
But for some reason it, it highlights one of cells even if the sum is 1
Can anyone tell me please what I do wrong?
Thanks in advance.
I am trying to use conditional formatting to highlight cells. if cell and next cell's sum is not =1
I tried =(BQ2+BR2)<>1
But for some reason it, it highlights one of cells even if the sum is 1
Can anyone tell me please what I do wrong?
Thanks in advance.