Sorry Suzanne

Didn't read your question properly.
You have an answer from Peo.
Conditional Formatting works the same in 2007 as earlier versions.

--
Regards
Roger Govier



"Suzanne" wrote in message
...
I don't want to copy the formula in the cell - just the formula for
conditional formatting.

"Roger Govier" wrote:

Hi Suzanne

Copying formatting does not do anything to formulae.
Copy and Paste
or CopyPaste SpecialFormula will change the formula as appropriate.
This is the same in all version of Excel.

Maybe it has changed the formula, but the result you are seeing is
staying
the same because you happen to have calculation set to Manual.
Click on the Formula tabCalculation section (far right)Click
Calculation
OptionsSelect Automatic.

--
Regards
Roger Govier



"Suzanne" wrote in message
...
In previous versions of Excel I could copy a formatting to another cell
and
the formula would move appropriately (as long as $ were removed from
reference) ie. =A9 would change to =A10 if copied down. In Excel
2007 I
am
finding that this is not happening - the comparative cell is staying
the
same
no matter where I copy it. Is there a different way to accomplish this
without doing a conditional formatting for each individual cell?