Add range to Conditional Formatting

[pizzaboyuk]

I already have conditional formatting set on a table column, can I add to the range without duplicating it through VBA?

I've tried copying and pasting the format to the additional range, but that just creates a new instance of the condition.


Any help would be greatly appreciated.

Thanks.

[TMS]

In the Applies to box, use, for example:

Please Login or Register  to view this content.

That is, separate ranges with a comma (,)

To continue the example:

Please Login or Register  to view this content.

[dflak]

Tables should copy down conditional formatting automatically. You have to "clear" all other conditional formatting out. Tables work on the principle of "if everything above me has the same thing, then I'll copy it down."

[pizzaboyuk]

Via vba TMS...

I have code that automatically inserts columns at the end of each working day.
Removing the current conditional formatting for the columns and re-applying them after a certain length of time may become quite intensive...

[TMS]

Sorry, can't second guess what your workbook, worksheets, tables, data, formatting and existing code looks like.

How do you want to proceed?

[pizzaboyuk]

In Excel, setup a table column with a conditional format assigned to it (eg. "=TRUE", colour it BLUE).

Now in VBA, insert a new column. Is it possible to add the new column to the conditional format "Applies To" range without duplicating it?

Here is the code I am currently using:

Please Login or Register  to view this content.

It duplicates the Conditional Formatting instead of just adding it to the "Applies To".

Is it possible to do something like:

Please Login or Register  to view this content.