Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Add Borders in Excel Automatically in Two Conditions

Date:2022-5-6 Author:Sandra

We usually select the cell(s) where we want to add the border firstly, then click the border list arrow from the Home tab to add borders. And click No Border to remove borders.

How to Add Borders in Excel Automatically in Two Conditions

Today, we are going to learn a totally different and useful way to add or remove borders automatically.

We first select the area from A2 to C20, then click the arrow of Conditional Formatting, and choose New Rule.

How to Add Borders in Excel Automatically in Two Conditions

Select the last choice, Use a formula to determine which cells to format.

Edit[ =$A2<>” “] in the box and click on Format button.

<>: it means not equal to.

” “: it represents a null value.

How to Add Borders in Excel Automatically in Two Conditions

We set the outline border and color.

How to Add Borders in Excel Automatically in Two Conditions

Hit Ok.

How to Add Borders in Excel Automatically in Two Conditions

Now, when you enter any data or content in column A, there would show borders from row A to C. If you delete the content, the border would be removed automatically.

How to Add Borders in Excel Automatically in Two Conditions
How to Add Borders in Excel Automatically in Two Conditions

If you only want to add borders to the cell which has content.  You can just change the [=$A2<>””] into [=A2<>””]

How to Add Borders in Excel Automatically in Two Conditions
How to Add Borders in Excel Automatically in Two Conditions
How to Add Borders in Excel Automatically in Two Conditions

That’s more useful and effective than adding borders from the Home tab.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *