Add Borders Dynamically When Cells Are Populated – Conditional Formatting In Excel
We cover how to add borders when cells are populated in Excel. In our example, we have a list of students and we have added borders around the names. However, as a default, when we add a new name, a border is not added and when we delete a name, the border is not removed. To overcome this, we can make our borders dynamic using conditional formatting. This ensures that they update as soon as cell contents are populated or removed.
Access the templates featured in The Excel Hub's video tutorials here:
https://theexcelhub.myshopify.com/
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• Add Borders Dynamically When Cells Are Pop...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: https://theexcelhub.com/
📸 Instagram: / theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]
Overview: (0:00)
Dynamic Borders Using Conditional Formatting: (0:39)