AutoFormat option in excel is a unique way of formatting data quickly, the first step is we need to select the entire data we need to format and then the second step we need to click on auto-format from the QAT and third step we need to choose the format from the different options.
On the Home tab, in the Font group, click the arrow next to Borders Button, and then click No Border Button.
Click Home > the Borders arrow > Erase Border, and then select the cells with the border you want to erase.
Where can you set the shading color for a range of cells in Excel?
A conditional format changes the appearance of cells on the basis of conditions that you specify. If the conditions are true, the cell range is formatted; if the conditions are false, the cell range is not formatted.