I have found the brilliant template created by Vertex42 - a masterpiece, at least to me, who is just learning. )
In it, whenever you add any row to any part of any sheet of the workbook, the conditional formatting rules' ranges neatly increment by the amount of rows you added, and do not create new rules for any added row (the problem I have in my file).
How did they achieve that?
Bookmarks