To highlight matching columns, we use this logical expression:
The reference to B4 is again mixed.
When either (or both) logicals return TRUE, the rule is triggered and the formatting is applied.
OR returns TRUEif any condition is TRUE.
If all conditions are FALSE, the OR function returns FALSE.
AND returns TRUEonly if all the conditions are met.
If any conditions are not met, the AND function returns FALSE.
