Mark,
Try 1 of these methods
1) Paste Special -> Formats works fine if there are no other formats
for the cell you wish to preserve, such as number formats, borders, or
other aspects of the format you are not adjusting conditionally.
2) CF = Conditional Formatting
Select the cells you want the CF applied to
hold Ctrl, and select at least one cell within the range that is
already contains the CF to be applied
Then Format->Conditional Formatting
Here you will see the conditional formats about to be applied
When you click OK, the CFs will be applied across the whole selection
Then Select just the 'newly' formatted cells and make the desired
changes.
Note that this only works when the cells to wish to copy the CF to
don't already contain conditional formats. If the selected range
contains more that one definition for any of the three rules, the
Conditional Formatting box will show these rules as being blank.
Source Rik @
http://excelusergroup.org/forums/p/497/1443.aspx
Good luck,
Tom
