I have the following question from a colleague:

I like to solve the following problem. I have an RC address in one cell
of the form, RC6, (current row, col 6). I like to copy and paste this to
another cell (or copy the conditional format portion involving a formula
of the above address form), but the address in the new place to reflect
its new row, that is, the address should remain as RC6 in the new place.
When I do the copy and paste, the row address changes to an absolute
address of the form R[-4]C6, which is the correct behaviour by the above
definition.

But if I start with a relative R[0]C6, the only form I know for a
relative row format, when copied it gets converted into an absolute RC6
at the new place. Is there a way to get the effect I want, or is this a
known bug (ala feature as defined by MS) in Excel 2000 (9.0.2720)?

TIA,
Alan Beban