Forum Discussion
Conditional formatting en masse
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.
I found a solution! (In case anyone else has this problem in the future and stumbles upon this post)
First, highlight A1:B1. Apply conditional formatting with the rule type "Format only unique or duplicate values". Select unique and format as desired.
Then, to apply en masse, but have them function independently, highlight A1:B1 again and double click the Format Painter. After that, hold the down arrow until all desired rows have had the rule applied to them.
If anyone knows of an easier way, please let me know!
Tyler your method worked fine but you can apply it to the entire column simply by clicking on the column letter at the top after double-clicking format painter. Brilliant.
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.
