Possible to expand formatting in columns ?

Dear all, i have only question.

I use macro. When i copy some row and paste it into checksheet as last row, table automatically expand and this row also take conditional formatting from upper cells. Conditional rule is only one, just application range auto expand. Thats ok.

But what about if i copy column, paste it to latest empty column, but it doesnt take conditional formatting from left (i mean expansion of range of one rule)

I know that i can copy paste also conditional formatting, but it seams that excell still create new and new rules (visually its ok), but i think from long time perspective it could have efect of slow excel file ?

Am i wrong ?

Thanks

Your document will create new rules every time you copy & paste those cells, true, but only time will tell if it will slow down your document.

Why not remove formatting & use:

range.rows.autofit
range.columns.autofit

This way, your formatting is done in code & not from a conditional format.