borders

Hey, I have a format data selection code. What I need now from it is to: Add vertical borders across each column in the selected range. Horizontal AND vertical across row(1) and last row of selected range. Throughout the selected range, if a cell is blank I don't want a vertical border E.G. \...

I just want some Conditional Formatting that will create 'All Borders' in that particular row (out to Column E) if there is a value in Column A. So if there was a value in Cell A23 such as "Example 1" then I want it to trigger the 'All Borders' Command for that row out to Column E. Thanks.

I've got a sheet with three columns. Data for one individual takes up 10 rows and 3 columns, then it skips 2 lines, and then the next person. I'd like to put "outside borders" around each individuals data and have no borders in between, in order to create more of a gap between each record. Is...

Hi Everyone! Aplogies but I know this seems REALLY basic but i really don't know how to go thru (i've been playing around with excel for a long time now). Anyone knows how i can put borders (all borders) in my table with gray lines instead of the usual black (automatic) lines? The lines look...

Hi I am new here and have a question regarding VBA coding. I am building a spreadsheet and I would like to be able to use VBA Code to bold the differences between sheet 2 and sheet 1. It is a steel pile schedule where each sheet is a revision and the changes to each revision needs to be bolded...

Hello all - I'm trying to get double borders on an excel spreadsheet that uses conditional formatting on each row. I know that excel doesn't support changing border types to double via conditional formatting because it would affect the row size, so what I tried to do is format all of the cells...

Hi all, I have been successfully Paste Special(ing) values into another workbook using this code: With Selection .PasteSpecial Paste:=xlPasteValues End With However as I am anal retentive and I like everything to look perfect I am wanting to Paste special the borders without any of the other...

Hello all, I am having an issue with my conditional formatting. I would like to just manually set all my borders for my worksheet, and have my conditional formatting ignore borders, but when I select no borders it just removes them from my conditional ranges. How do I fix this? Just in case...

For i = 1 To 1000 If Sheets("Income List").Range("A" & i + 2) <> blank Then Range("A1:N&i").Borders.LineStyle = xlContinuous End If Next I have also tried For i = 1 To 1000 If Sheets("Income List").Range("A" & i + 2) <> blank Then Range("A1:N"&i).Borders.LineStyle = xlContinuous End If Next...

Hi, I am trying to have the last row in each print page have a xlmedium border line. When I look at the print preview, there is not border. Below is my latest attempt to add the border, I loop through every single column and add a border (Cell below PBreak and Cell above PBreak). I have merged...

Hi, I've created a macro that applies filter criteria to two Excel data tables on the same sheet. In the row immediately following each of the data tables, there is a row which contains Subtotal functions. The subtotal row (below the data table) is formatted with a double-line border along the...

When I save Excel as htm/html, the borders are stripped and collapsed. How can I save it with the borders intact? Here are snippets from the html: table border=0 style='border-collapse:collapse style='border-left:none border-top:none;

I have conditional formatting set for a range of cells. In that conditional formatting, it contains, among other formats, formatting for the borders. I want to remove the conditional formatting of the borders (only), so that the original borders on the cells remain. I can set the conditional...

Hello, I am having some trouble with VBA. I am trying to write a sub that will make the border thick if a certain cell is not empty, and thin if a different cell is not empty. I can't seem to use the "With Selection.Borders(x1EdgeTop) twice. If B.Value <> "" Then With...

I have a VBA command that when a button is clicked it puts borders around certain cells within a worksheet. I want those borders to disapear and return to normal format when the autofilter arrows are clicked in row 1. I have not been able to figure this out. Any help would be great

I can't seem to find this elsewhere on this site though I'm SURE someone's asked: I print the same spreadsheet several times with different filters and hidden columns - and to that end "Custom Views" helps a TON. However when I hide a column it (obviously) changes the border style separating...

Below is my current Macro, and I could use some help with a few things. 1) For each F,G,H,I,J end sample ranges that use the formulas, I want a Medium thickness, continuous, top Border. Also, I would like the cell to be highlighted yellow. 2) Sometimes the J column formula will show up as...

I have "inherited" several reports for Excel 2010 where the data is generated via VBA but the formatting of the reports, including borders, merged cells, font styles, etc were manually added to the sheets. I wish to replicate these formatted characteristics into the VBA modules that create the...

Hi All, I was wondering if anyone knew of a way to write a macro that would add a top border to some cells in a selected range. All of my number data is columns I:O with subtotals every so often (example of columns F:O below): <TABLE style="WIDTH: 451pt; BORDER-COLLAPSE: collapse" border=0...

I have a column with a series of items, some of which repeat. The repeated items need to appear grouped together. I set the horizontal borders between them as heavy lines and added a conditional format that checks to see if the content of one line equals the line above, and if so changes the...