Copy Problem with 2007 Conditional Format

[Andy]

The link below will let you see what I am doing. I have created the formula
in F3 based upon the values for D3 and E3, but when I copy it down through
the rows, all references within the conditional format, still relate to D3
and E3. I would want the conditional format for F19 to be E19<D19, but it is
not... Am I missing something really simple here?! I have tried without any $
at all and it still does not work.

Any help appreciated please.

http://s662.photobucket.com/albums/uu343/AndyTheAnimal/?action=view&current=NewPicture.png

 

[Peo Sjoblom]

Make sure there are no $ signs for the formulas or they won't copy in a
relative manner

--


Regards,


Peo Sjoblom

 

[David Biddulph]

I don't know much about the difference between 2003 and 2007, but I'm sure
that you'll need to get rid of the $ in front of the 3 in the references.

 

[Ron]

This was not an issue in Excel97. I've just recently converted over to
Excel2007 and have experienced this same issue when coying a cell's
conditional format into a group of other cells (A1 into A2:A10). When you
examine on the cells A2:A10 the conditional statement does not reflect the
correct reference cell. i.e cell A1 dependent on <B1, A2 <B2, A3 <B3, ....
A10< B10. What I see is A2 <B1, A3 <B1, A4 <B1, ... A10 <B1.

p.s. I do not have the $ in the refecence cell so it should be incrementing.
Hopefully someone know how to correcft this issue.
---------------------------------

 

[Gord Dibben]

Something I have noticed with 2007 CF on my setup.

If you select C1:C10 and add new rule.

=A1<B1 then if you look at the CF formula of individual cells in C1:C10

the =A1<B1 does not increment in the Manage Rules dialog so I see =A1<B1 on
all cells in Manage rules.

BUT..............the CF rule does work as if it had incremented.

This you can see by changing values in A1:A10 and B1:B10

Same when you simply drag/copy down from C1 to C10

Also try this................

Enter the rule in C1

Double-click format painter and drag down to C10

C2:C10 rule is =A2<B2 for those cells but again the CF rule works as if
it had incremented.

I cannot get =A2<B1, =A3<B1, =A4<B1 as you have described.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

In your other post Biff explains "That's the way it is"


Gord