software

How can I format an entire column using conditional format? I keep getting an
error message when I choose the column.

Yes but you do it by first selecting the column, then applying the format on
the active cell

--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Patti Fquot; gt; wrote in message
...
gt; How can I format an entire column using conditional format? I keep getting
gt; an
gt; error message when I choose the column.
You'll need to provide more information. When you say you're getting an
error message, does this mean that you aren't even able to select the column?
Or is the error coming from your Conditional Formatting formula? What is
the error message? It would also be helpful if you provided an example of
how you want your formatting to appear, and what conditions should trigger it.

quot;Patti Fquot; wrote:

gt; How can I format an entire column using conditional format? I keep getting an
gt; error message when I choose the column.

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., quot;$c1=42quot;), 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)

RESOLOVED
The problem I was having had nothing to do with cell references; it was a
logic error. Relative refs work fine in conditional formatting formulae.What quot;methodquot; did you use to set the CF?

Use the quot;Use a formula to determine which cells to formatquot; method.

=C1=42--
Biff
Microsoft Excel MVPquot;spai461quot; gt; wrote in message
...
gt; I'm new to Excel 2007. Trying to apply conditional formatting based on a
gt; formula to a whole column. In the 2003 version, if I used absolute
gt; column/relative row references (e.g., quot;$c1=42quot;), the conditional
gt; formatting
gt; automatically adjusted the row references such that in the example above
gt; it
gt; would go $c1, $c2, $c3, etc...
gt;
gt; But, in this version if I select a column and use a relative reference, it
gt; only works in the first row; and if I check the rule for just one cell
gt; with
gt; in that column it shows the same reference as in the first row (i.e.,
gt; $c1),
gt; and it's the same in every row for the condition. Yet, the conditional
gt; formatting help subject says explicitly in a note that relative references
gt; are adjusted for the selected range.
gt;
gt; Is this a glitch, or am I missing something?
gt;
gt; Using: Excel 2007 (12.0.6300.5000) SP1 MSO (12.0.6213.1000)
I'm having the same issue, but have not found the resolution as you did.
What gives? I still can't get the cf to extend down a column with the
correct references - it still wants to compare to the first row. Thanks for
any help you can provide.

quot;spai461quot; wrote:

gt; I'm new to Excel 2007. Trying to apply conditional formatting based on a
gt; formula to a whole column. In the 2003 version, if I used absolute
gt; column/relative row references (e.g., quot;$c1=42quot;), the conditional formatting
gt; automatically adjusted the row references such that in the example above it
gt; would go $c1, $c2, $c3, etc...
gt;
gt; But, in this version if I select a column and use a relative reference, it
gt; only works in the first row; and if I check the rule for just one cell with
gt; in that column it shows the same reference as in the first row (i.e., $c1),
gt; and it's the same in every row for the condition. Yet, the conditional
gt; formatting help subject says explicitly in a note that relative references
gt; are adjusted for the selected range.
gt;
gt; Is this a glitch, or am I missing something?
gt;
gt; Using: Excel 2007 (12.0.6300.5000) SP1 MSO (12.0.6213.1000)

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

quot;spai461quot; wrote:

gt; I'm new to Excel 2007. Trying to apply conditional formatting based on a
gt; formula to a whole column. In the 2003 version, if I used absolute
gt; column/relative row references (e.g., quot;$c1=42quot;), the conditional formatting
gt; automatically adjusted the row references such that in the example above it
gt; would go $c1, $c2, $c3, etc...
gt;
gt; But, in this version if I select a column and use a relative reference, it
gt; only works in the first row; and if I check the rule for just one cell with
gt; in that column it shows the same reference as in the first row (i.e., $c1),
gt; and it's the same in every row for the condition. Yet, the conditional
gt; formatting help subject says explicitly in a note that relative references
gt; are adjusted for the selected range.
gt;
gt; Is this a glitch, or am I missing something?
gt;
gt; Using: Excel 2007 (12.0.6300.5000) SP1 MSO (12.0.6213.1000)

Are you sure you resolved? If I copy and paste conditional formatting in a
single cell it goes very well, but if I copy on a multiple cells I had the
problem that you described and the $ doesn't works (doesn' change the number
of row but use a range). Who can help me? Thanks

quot;spai461quot; wrote:

gt; RESOLOVED
gt; The problem I was having had nothing to do with cell references; it was a
gt; logic error. Relative refs work fine in conditional formatting formulae.
gt;

The problem as I see it is not the conditional formatting, but Excel's
insistence on applying absolute references on the quot;Applies toquot; cells.

I selected a range of cells and applied a formula for conditional formatting
that works as expected on this selected range of cells. Yet when I try to
copy this rule to other rows, as previously noted, it just increases the
range of cells that gets affected by it. I want to apply this same rule as a
separate rule to a different row.

Is this possible? If so, please tell me how?

quot;reylonquot; wrote:

gt; Are you sure you resolved? If I copy and paste conditional formatting in a
gt; single cell it goes very well, but if I copy on a multiple cells I had the
gt; problem that you described and the $ doesn't works (doesn' change the number
gt; of row but use a range). Who can help me? Thanks
gt;
gt; quot;spai461quot; wrote:
gt;
gt; gt; RESOLOVED
gt; gt; The problem I was having had nothing to do with cell references; it was a
gt; gt; logic error. Relative refs work fine in conditional formatting formulae.
gt; gt;