How do I use conditional formatting for an entire column?

[Patti F]

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

[Peo Sjoblom]

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

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Patti F" <PattiF@discussions.microsoft.com> wrote in message
news:C2B80B0E-97DF-4187-94E2-0B18F1602A1E@microsoft.com...
> How can I format an entire column using conditional format? I keep getting
> an
> error message when I choose the column.

[Elkar]

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.

"Patti F" wrote:

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