Conditional formatting across multiple columns [Solved]

wolfy1s13 3 Posts Sunday May 27, 2018Registration date May 28, 2018 Last seen - May 27, 2018 at 05:32 AM - Latest reply: wolfy1s13 3 Posts Sunday May 27, 2018Registration date May 28, 2018 Last seen
- 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

TrowaD 2367 Posts Sunday September 12, 2010Registration dateModeratorStatus June 19, 2018 Last seen - May 28, 2018 at 11:05 AM
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
wolfy1s13 3 Posts Sunday May 27, 2018Registration date May 28, 2018 Last seen - May 28, 2018 at 02:36 PM
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