One of the best easiest ways to make a spreadsheet look nice, especially if it is going to be printed, is to add borders. But, if you are constantly adding data to your spreadsheet, that means you also have to be constantly updating those borders. Below is a way to make borders appear automatically as you add data to your spreadsheet.
We shall use conditional formatting using a formula to achieve this auto boarders quickly.