ExcelBanter - How can I keep conditional formatting when adding rows to excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I keep conditional formatting when adding rows to excel? (https://www.excelbanter.com/excel-discussion-misc-queries/125511-how-can-i-keep-conditional-formatting-when-adding-rows-excel.html)

Excel one tenth guru

How can I keep conditional formatting when adding rows to excel?

If I add new rows from another spreadsheet, the formatting does not
automatically apply to the new rows.

All times are GMT +1. The time now is 02:47 PM.