Hello, I have a Worksheet which I will keep adding data to new rows – I have set the sheet up so it has conditional formatting.

My issue is, if I copy the conditional formatting to all the blank rows, when we come to print the sheet it prints the blank rows.

I know you can set the print area but this isn’t ideal for some of our more novice users so I was wondering is there a bit of code which can copy the conditional formatting down to each new row where there is data?

Thanks,
Tom