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.
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.
Ignore my last reply, I deleted it. I needed to use the absolute reference to solve my issue. Thank you so much Sergei! This is great.