Copy Problem with 2007 Conditional Format
 

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/u...NewPicture.png

Copy Problem with 2007 Conditional Format
 

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

--


Regards,


Peo Sjoblom


"Andy" wrote in message
...
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/u...NewPicture.png

Copy Problem with 2007 Conditional Format
 

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.
--
David Biddulph

"Andy" wrote in message
...
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/u...NewPicture.png