What "method" did you use to set the CF?

Use the "Use a formula to determine which cells to format" method.

=C1=42


--
Biff
Microsoft Excel MVP


"spai461" wrote in message
...
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)