I'm having issues in border formatting to produce a clean looking document after saving as a PDF. I need to use "Save as PDF" due to there being multiple tabs in my work book. This is an excel file that is updated weekly to present at my workplace in order to give updates on how we are tracking...
I am looking for a vba script that can set borders like the image here.
The data can grow or shrink. And when it does, I want to adapt to it with the borders.
I hope someone can fix it for me.
Thanks in advance.
I want to set up conditional formatting so that if a cell has data the entire row will automatically get borders. The possible columns that can have data are A:E. The rule I am using is =OR(A1<>"",B1<>"",C1<>"",D1<>"",E1<>"") and applies to =$A:$E. This mostly works but if for example only cell...
I have set conditional formatting in specific range. If is not empty then background color = green + outer borders.
I sometimes use merged cells in this range and by merged cells is the borders unfortunately not complet.
Is there any way how to solve it?
thank you very much
In my team we have a daily set of data which we need to analyse and send to the teams members.
As the summary of analysed data is sent by email I want to send it in a way that the data has borders on it.
In terms of columns, it goes from column A to L.
In terms of rows, data will vary from...
I have the below coding and it works great, but I'd like add on to it. Right now it puts a border around all cells that contain value. My number of columns will always be the same (A-Y), but my rows will be different. How can I add the border to the blank cells right after my last column that...
I'm using Example 2 of the following link to e-mail a range within a sheet:
However, when doing this, the borders are not maintained within the body of the e-mail.
Using a single thickness border in the sheet doesn't show up in the...
I have had some brilliant help in this forum with this code.
What I would like to try and add when creating the new Column A is to ensure any new text is set to "Top Align" and Create an "All Borders" around the New Cells in Column A
Dim ws As Worksheet
For Each ws...
I know this issue has been addressed but none of the solutions really solve my problem; hope someone can help me.
I have a spreadsheet with a lot of data that i was able to manipulate with codes and the last part is to now format with borders and blank cells between to make it...
So my sister has an eye degenerative disease and has a hard time seeing the green highlighted border of a cell in Excel when hover over or clicked on on comparison to the black borders of the rest of the cells. Is there a way she change change.the colors so she can better see them?
Following is some VBA code I am wrestling with in trying to create borders that stay within in a dynamic range.
As you can see from the following VBA code and image, I am able to get the code I have written to be dynamic in responding to finding the overall range of the data I want to enclose...
I thought Borders, is a properties of Range object and its data type is Borders. So the in MS page it says the follwing (without s)
Worksheets("Sheet1").Ovals(1).Border.Weight = xlMedium
I am looking for a way to place borders around my cells in a unique way.
So my range is B2:J16 with columns E and H excluded.
So like in cell B2 and C2 we have same items "B" and "B" so we have the border around the range B2:C2 with no line in between B2 and C2. That's we show only border...
In my Excel 2016 form, I seem to have a disappearing border. I have columns of info that are completed using the drop down box and data validation. If I make a selection and use the auto fill, my upper and lower borders in the cells disappear. It then becomes a continuous column of info...
VBA code to put borders base on cell value
if cell B7 > 0 green border
If cell B7 < 0 red border
outside borders only go around B4 to B8
I want to do this for B7, around B4 to B8
D7, around D4 to D8
F7, around F4 to F8...
I am using code to apply basic borders around all used cells in a worksheet. Perfectly, this applies borders to the anticipated range. I use the same range to set the print area. I'd like to modify the macro to modify this range so as to set the print area AND apply borders to all cells...
OK for some reason while using a bunch of named ranges to clear out the data the borders get changed to the heavy border. So after a bunch of playing around with it I see that if I run the sub with nothing in the cells to clear it doesn't change any formatting. But I type something in the top...
I'm trying to customize my toolbar with a button that sets the borders of a cell(s) to thin/grey.
To start, I use Format/Cell to set cell border color to grey, thickness to thin, click all the borders. Then..
And dragging the Border button to my toolbar...