Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy conditional format without using format painter | Excel Worksheet Functions | |||
Copy conditional format | Excel Discussion (Misc queries) | |||
Conditional format won't copy | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |