Question:
I want every cell in row 2 to have red background if its value is different
than the corresponding cell in row 1.
I can do this to cell A2 if in the conditional formatting field I say
=A2<A1 but when I copy the formatting (using the brush), the condition
continues to be A2<A1 and not B2<B1 for cell B and so forth.
How do I copy the conditional formatting adjusting the references like the
copy cells command do?
Thanks.