Conditional formatting across multiple columns [Solved/Closed]

Report
Posts
3
Registration date
Sunday May 27, 2018
Status
Member
Last seen
May 28, 2018
-
wolfy1s13
Posts
3
Registration date
Sunday May 27, 2018
Status
Member
Last seen
May 28, 2018
-
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 row 3 to row 30, where effectively the formula becomes =AND(BX4=BY4,BX4 <> "") --> =AND(BX30=BY30,BX30 <> "")

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

Thanks in advance
Terry Taylor

2 replies

Posts
2591
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 11, 2020
396
Hi Terry,

Using conditional formatting can be quit tricky.

Since you don't want the columns to change you will have to use the absolute symbol ($) in front of them:
=AND($BX3 = $BY3,$BX3<>"")
If you didn't select the range BX3:BY30 before hand, then change applied range to:
=$BX$3:$BY$30

Best regards,
Trowa
Posts
3
Registration date
Sunday May 27, 2018
Status
Member
Last seen
May 28, 2018

Thank you very much for your response. My problem is now resolved and was due to the omission of the first $ in the AND statement