border group blanks

  1. L

    Conditional Formatting: Find last row with text and make the following rows remove all formats

    I have a table with 3 columns. The table contains formulas in all three columns that returns data. See example below: <tbody> Column B Column C Column D Person # # Alex 5 4 Phil 6 Luke 19 7 John 2 Tori 2 </tbody> You'll notice that after "Tori" there are...
  2. C

    Conditional Format, Filter or VBA Challenge w Border Lines and Blanks Sometimes Present

    Having trouble trying to figure out how to do 2 things with the following data with VBA: 1-separate by NSN groupings (draw border above & below grouping from A to Z columns) 2-separate by LOC (location) groupings (EVEN when blanks are present!) (draw border around that group of 'like locations')...

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
Back
Top