When copying one cell containing conditioanal formatting incorporating
Relative Reference - the relative references in the new cells are not
updated.
I.e. C1 with reference in conditional format '=$C1'
when copied to C2, the relative reference is updated to '=$C2'
However, when copied to a range. i.e. C3:C4, the relative reference in both
C3 and C4 will contain =$C3 while the applies to field is updated to indicate
the rule will apply to $C$3:$C$4
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=4de09...-b46a-4
Microsoft Office