Previous Topic Next Topic

Conditional formatting across multiple columns

Solved/Closed
wolfy1s13 Posts 3 Registration date Sunday May 27, 2018 Status Member Last seen May 28, 2018 - May 27, 2018 at 05:32 AM
wolfy1s13 Posts 3 Registration date Sunday May 27, 2018 Status Member 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

2 responses

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
May 28, 2018 at 11:05 AM
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
0

Similar discussions

Conditional Formatting: Font color for entire column based on another column
Kitkatpdx -
Mazzaropi -

5 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Conditional formatting with multiple rules and blank text cells
PaiviM -
PaiviM -

6 responses
Formula for conditional format to color cells
kipp2019 -
TrowaD -

14 responses
Conditional Formatting range of date cells based on another cell
cleaverr -
cleaverr -

7 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses