G
Gary Keramidas
i really don't like excel 2007, but i'm playing around with the conditional
formatting color scales, data bars, etc.
i have data in columns c:e
i apply cond formatting to row 2, it's correct, this is the formula it creates:
=$C$2:$E$2
if i copy formatting one row at a time it works correctly:
=$C$3:$E$3
but, if i replicate the formatting, using format painter or copy/formats, for
multiple rows, i end up with this formula for row 27:
=$C$3:$E$27
can someone explain this to me?
formatting color scales, data bars, etc.
i have data in columns c:e
i apply cond formatting to row 2, it's correct, this is the formula it creates:
=$C$2:$E$2
if i copy formatting one row at a time it works correctly:
=$C$3:$E$3
but, if i replicate the formatting, using format painter or copy/formats, for
multiple rows, i end up with this formula for row 27:
=$C$3:$E$27
can someone explain this to me?