ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/254983-conditional-formatting.html)

Mickey5

Conditional Formatting
 
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?

Luke M

Conditional Formatting
 
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?


Ms-Exl-Learner

Conditional Formatting
 
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?


David Biddulph[_2_]

Conditional Formatting
 
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?





All times are GMT +1. The time now is 04:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com