I have two columns which if equal(unless blank), I wish to fill in with a colour. I have defined the range as the two columns(BX3:BY3) and specify the formula to be evaluated as
=AND(BX3 = BY3,BX3"")
All that happens is the first column only gets filled in.
I then wish to apply the formatting down the columns from ...