Dynamic Borders using Conditional Formatting

preview_player
Показать описание
How to create automatic borders using conditional formatting so that when you data increases or decreases borders are always adjusted.

Also, check these videos if you want to learn more

1 Min Excel: If you enjoy short videos check this section

Excel: Check this playlist for Excel-related things

Keyboard Shortcuts: Check this section to save some time in everyday excel work

Pivot Tables: Check this playlist for Pivot Table, Slicers, and Auto refreshing reports

Power Query: Check the Power Query playlist for Data Preparation & its Automation

Power BI: Check the PowerBI related videos for Business Intelligence, Dashboard & Visualisations

Please subscribe to our channel and Follow us on other social media platforms for regular updates :

Рекомендации по теме
Комментарии
Автор

Thanks for the very useful technique!.... More power to you....

BenDieselBasicAutomotive
Автор

Even it can be done thru excel table. Press ctrl+T.

santroramki
Автор

Is there any solution to the rule that still applies if we have inserted/deleted any row (between/new)? I did that and the rule is not working in this case. Can it be dynamic in the whole sheet?

SunnyCool
Автор

Even it can be done thru excel table. Press ctrl+T.

santroramki