Conditional formatting across multiple columns [Solved]

Posts
3
Registration date
Sunday May 27, 2018
Last seen
May 28, 2018
- - Latest reply: wolfy1s13
Posts
3
Registration date
Sunday May 27, 2018
Last seen
May 28, 2018
- May 28, 2018 at 02:36 PM
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
See more 

Your reply

2 replies

Posts
2440
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 13, 2018
0
Thank you
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
Respond to TrowaD
Posts
3
Registration date
Sunday May 27, 2018
Last seen
May 28, 2018
0
Thank you
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
Respond to wolfy1s13