I want to add a column to a speadsheet that has been conditionally formatted,
I want the column to be included in the rules. How do I do this?

Copy a column that already has the rules you like, then paste - insert copied
cells
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Mickey5" wrote:

I want to add a column to a speadsheet that has been conditionally formatted,
I want the column to be included in the rules. How do I do this?

Copy the column in which you are having the Conditional Formatting and select
the column in which you want to apply the conditional fomatting and do right
clickPaste SpecialSelect Formats and give Ok. Now the Format and
Conditional formatting is applied to the current Column.

Note: Paste special will get activated once the copy is done.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Mickey5" wrote:

I want to add a column to a speadsheet that has been conditionally formatted,
I want the column to be included in the rules. How do I do this?

Format painter.
--
David Biddulph

"Mickey5" wrote in message
...
I want to add a column to a speadsheet that has been conditionally
formatted,
I want the column to be included in the rules. How do I do this?