Conditional formatting across columns [Closed]

Registration date
Sunday May 27, 2018
Last seen
May 28, 2018
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 column from row 3 to row 30.

I have spent some time on this looking on the web for guidance but to no avail. Can you help

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!