Forum Discussion
Solved
Conditional formatting en masse
Hello! I am trying to accomplish the following process: If A1 and B1 cell contents don't match, format both A1 and B1 If A2 and B2 cell contents don't match, format both A2 and B2 If A3 and B3 ...
IMHO, easier with formula
=$A1<>OFFSET($A1,0,1)
or simply
=($A1<>$B1)
applied to your entire range
With format painter you generate as many rules as rows in your range.
Hi Tyler,
It's like a rule
=A1<>OFFSET(A1,0,1)
Thank you for taking the time to respond, Sergei. However, unless I misunderstand, this does not solve my problem. I need to apply this rule to every row in the sheet and have both cells affected by the conditional format. Thank you again! :)