Conditional formatting across multiple columns Solved/Closed

Question

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

TrowaD · Answer

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

wolfy1s13 · Answer

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

Conditional formatting across multiple columns

2 responses

Similar discussions

Subscribe To Our Newsletter!