Registration date
May 27, 2018
Last seen
May 28, 2018

Conditional formatting across multiple columns [Solved]

Hi there, 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 ... Read more