For example, the formulae for cell E9 ore below
=VALUE(LEFT(E$6,2))*0.95
=VALUE(LEFT(E$6,2))*1.05

I don't understand that. A cell, E9, can contain only a single formula.

????

Is there some way to say =VALUE(LEFT("current row -2",2))*0.95
in such a way that when the row is copied down
"current row-2" becomes "current row-3"?

Yes, but I need to understand what you're trying to do, what cell the
formula is entered in and what cell you want to reference.

=VALUE(LEFT(E$6,2))*0.95

What's in cell E6? You may not need the VALUE function:

=LEFT(E$6,2)*0.95

--
Biff
Microsoft Excel MVP


"IanC" wrote in message
...
I have a spreadsheet with a block of 10 rows by 8 columns with conditional
formatting with absolute references to row 6.

I need to change these to reference row 7. I can edit each instance on one
row (16 in total) then copy the row down but, as the process may need to
be repeated in the future, can I use an offset reference instead of an
absolute reference, yet still retain the ability to copy the rows down?

For example, the formulae for cell E9 ore below
=VALUE(LEFT(E$6,2))*0.95
=VALUE(LEFT(E$6,2))*1.05

E$6 needs to be E$7.

Is there some way to say =VALUE(LEFT("current row -2",2))*0.95 in such a
way that when the row is copied down "current row-2" becomes "current
row-3"?

---
Ian
---