borders

  1. K

    Conditional Formatting Borders

    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...
  2. I

    Conditional formatting by merged cells

    Hello, 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 Miroslav
  3. E

    add borders to range of cells that changes each day

    Hi 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...
  4. S

    VBA Border

    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...
  5. L

    MailEnvelope and borders

    Hi I'm using Example 2 of the following link to e-mail a range within a sheet: https://www.rondebruin.nl/win/s1/outlook/bmail3.htm 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...
  6. P

    VBA Code Help with Text align and All Borders

    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 Sub EnterTeamName() Dim ws As Worksheet For Each ws...
  7. W

    VBA code to set text color in an entire column & draw border (not a border grid)

    I'm trying to achieve two things using VBA code: set all text entered in column C to red draw a thick-lined border around cells A1:B2 without any internal grid lines Any ideas? Thanks!
  8. M

    VBA to format Cells with Borders based on Column Value ( merged cells)

    Hello Everyone, 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...
  9. K

    Border around cell that hover over

    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?
  10. A

    Cell border

    After applying a new Interior.Color, how do you keep (or restore) the small dotted borders around each cell ?
  11. B

    Dynamic Range Borders – VBA code assistance

    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...
  12. L

    border or borders?

    Hi 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 https://docs.microsoft.com/en-us/office/vba/api/excel.border.weight Thank you.
  13. kelly mort

    Set borders dynamically with vba

    Hi, 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...
  14. T

    Disappearing borders

    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...
  15. W

    borders based on cell value

    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...
  16. M

    Filling to end of page with borders / print area

    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...
  17. M

    VBA ClearContents changes formatting?

    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...
  18. J

    Cell Border Color

    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.. View Toolbars Customize Commands Format And dragging the Border button to my toolbar...
  19. S

    VBA Add border to dynamic rows but static columns

    I am needing to add the right border and last row bottom border for a variable set of data. The columns will always have data in columns "A" through "I". Starting with row 27 and ending with a variable row. Anything would be great. Thank you in advance!
  20. H

    Macro to insert all borders on all sheets

    I have written code to insert borders on all sheets from row 9 up to the row before where total appears in Col A (could be total repairs, total expenses etc) I need the borders to be from Col a to the last Column Containing Text in Row 9. Your assistance is much appreciated Sub...

Some videos you may like

This Week's Hot Topics

Top