Hi, I have the same problem. When you paste you cannot decide with $ if
change automatic or not the row number. Nothing to do with excel 2007. Some
one has resolved the problem? Thanks

"spai461" wrote:

I'm new to Excel 2007. Trying to apply conditional formatting based on a
formula to a whole column. In the 2003 version, if I used absolute
column/relative row references (e.g., "$c1=42"), the conditional formatting
automatically adjusted the row references such that in the example above it
would go $c1, $c2, $c3, etc...

But, in this version if I select a column and use a relative reference, it
only works in the first row; and if I check the rule for just one cell with
in that column it shows the same reference as in the first row (i.e., $c1),
and it's the same in every row for the condition. Yet, the conditional
formatting help subject says explicitly in a note that relative references
are adjusted for the selected range.

Is this a glitch, or am I missing something?

Using: Excel 2007 (12.0.6300.5000) SP1 MSO (12.0.6213.1000)