How to automatically create valuable cell borders in Excel

When setting up a table of data in Excel, if we just need to format the table at a basic level, then adding borders to the table also ensures the creation of an Excel table. And when processing the table there will be cases where we fill in the value after calculating. Instead of having to manually add table borders, you can automatically create borders for valuable cells in Excel. To create automatic borders for valuable cells in Excel, users will use the conditional formatting feature and guided by the Network Administrator in the following article.

1. How to format borders and background colors for Excel tables

Instructions to create automatic borders for cells containing Excel values

Step 1:

The user highlights the area that needs to be facilitated when entering a value and then press Conditional Formatting> New Rule .

How to automatically create valuable cell borders in Excel Picture 1

Step 2:

Display the New Formatting Rule dialog box, click on Use a formula to determine which cells to format . Then again the New Formatting Rule dialog box, enter the formula = B13 <> '' and click Format to continue. B13 is the first cell in the selected area.

How to automatically create valuable cell borders in Excel Picture 2

Step 3:

In the Format Cells dialog box, we click on the Border tab and then click on select Outline to create the border for the cell. Click OK to save the new format. If you like, you can choose the border style and color if desired.

How to automatically create valuable cell borders in Excel Picture 3

Finally click OK to apply conditional formatting to the data table.

How to automatically create valuable cell borders in Excel Picture 4

Now that we do the calculation, enter the values ​​in the cells at the original selected area. The result of the cell values ​​is automatically added borders with the type of border format you set.

How to automatically create valuable cell borders in Excel Picture 5

See more:

1. How to use conditional formatting in Microsoft Excel 2016
2. How to calculate and color blank cells in Excel
3. 4 basic steps for alternating coloring of lines in Microsoft Excel
4. How to automatically highlight rows and columns in Excel

I wish you successful implementation!