First of all, open Excel, design the Contract Information table header, as shown below
Select $a: $F area, then select Start in the Ribbon, and click Conditional Formatting on the toolbar under Start to pop-up the menu window
From the menu that pops up, select the new rule option
In the new Formatting Rule window that pops up, select the use formula to determine which cells to format option, and edit the rule descriptions below the window to set the formula and format separately
In the formula bar, enter the formula "=or" ($A 1: $F 1<> ""), and then click the Format button below
In the Format Cells window that pops up, select borders, select lines, select Outline, click OK, and return to the previous window.
Then click the OK button to exit the Edit Formatting Rules window
Congratulations, you have finished setting the conditional formatting border.
Next, let's test that the table border is set correctly?
The table border is automatically increased when you enter content in a column in a table blank row A to column F. Down and so on, you can automatically generate a table border, whereas the table border will automatically disappear.
Classification: