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