border auto format

  1. S

    VBA Code to add thick outside border to cells containing specific text

    Hi Everyone, I'm trying to create a macro to edit/format pivot tables on one of my worksheets. This is the macro I have so far (there are 5 pivots): Sub EDIT_PIVOTS() ' ' EDIT_PIVOTS Macro ' ' Sheets("PIVOTS").Select Rows("1:30").Select Selection.EntireRow.Hidden = False...
  2. D

    Adding Think Border Around Rows With Same Cell Value

    Hello, This is my first post here. I was sure I would be able to find what I was looking for without posting however I didn't. I would like to add a thick border around rows that share a common value I have Column B titled Group ID and I would like to have a thick border placed around all the...
  3. D

    Change borders/gridlines of cells in rows A, B, C & D when cells in row E contains no blanks

    Hello everybody, I am currently sitting with the following material overview file in Excel: I have made some conditional formatting so whenever I enter a number in column E the entire row gets highlighted. Unfortunately, this erases/makes invisible my dark gridlines/borders from before...
  4. V

    Borders Around Cell Fill Down

    This forum has been wonderful helping me learn about macros and vba. I come back to the group to see if I can get assistance on how to fill down a border to the last row. On a pre-designed template with the All Borders around each cell beginning row 6 - row 27 to column H. My macro brings data...
  5. A

    Dynamically Adding a Border Based on Rows Left in Each Section (Excel VBA)

    I created a macro that is pulling in data from another sheet and pastes it into a new spreadsheet. It pulls in 3 main sections of data. It pastes it all, does a VLOOKUP on the corresponding columns it needs information based on what it pulled in. After it's done that, I have a "Remove" macro...
  6. J

    Automatically adding border line after a change in value in a column

    I've looked at a couple other posts, but haven't been able to make this work for my situation using VBA. I want a thin border along the bottom of the cells in columns A:K whenever the value in column A changes. So, _A___B____C______________K__ 234 234 245 245 245 267 299 299 Becomes...
  7. C

    Formatting Border Only If Text Is Entered

    Hello There, I am currently trying to create a spreadsheet, it contains several sheets. I have written a formula so when you enter 1 in column A it looks up the remainder of the row from a master sheet. My problem is depending on the month of the year depends on how many rows will be...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top