Excel 2007 Conditional Format with Formula
 

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?

Excel 2007 Conditional Format with Formula
 

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?

Excel 2007 Conditional Format with Formula
 

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?

Excel 2007 Conditional Format with Formula
 

Not to worry - I figured it out for myself. for anyone else who may wish to
know: the formula portion of conditional formatting has changed from previous
versions. Now you actually have to refer to both cells involved - not just
the comparative cell. For example:

In previous versions if you were in cell k9 and wanted it formatted if it
equaled m9 you would just type "=m9"
Now you would have to type: "m9=k9"

"Suzanne" wrote:

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?

Excel 2007 Conditional Format with Formula
 

It depends on what part you used, if you selected cell value equal to yes
but that is not using a formula, if you choose formula is then no, you need
to refer to both cells like

=K9=M9


--
Regards,

Peo Sjoblom




"Suzanne" wrote in message
...
Not to worry - I figured it out for myself. for anyone else who may wish
to
know: the formula portion of conditional formatting has changed from
previous
versions. Now you actually have to refer to both cells involved - not
just
the comparative cell. For example:

In previous versions if you were in cell k9 and wanted it formatted if it
equaled m9 you would just type "=m9"
Now you would have to type: "m9=k9"

"Suzanne" wrote:

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?

Excel 2007 Conditional Format with Formula
 

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?