1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How can I create an automation that applies a custom border to selected cells?

Our take

Creating an automation in Excel to apply a custom border to selected cells can significantly enhance your workflow. By setting up a simple macro, you can save time and ensure consistency in your formatting. This process allows you to highlight important data with a thick red outline at the click of a button. Whether you're new to Excel or looking to streamline your tasks, this guide will help you implement an efficient solution that fits seamlessly into your daily routine.

Hello all. I just got a new job and I work in excel quite a bit.

In this job, I have to download a spreadsheet and select a few cells to highlight with a custom border (just a thick red outline).

I am trying to save myself time and just have a button to press (after selecting my cells) that will apply the boarder but I can't figure out how to do that.

Thanks everyone for your input and have a great day!

submitted by /u/Peetahbread
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article