excel 2007 conditional formatting question

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top