border

I am trying to get the highest grade per row with VBA. <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid #CCC ; }...

hi all.. how to lookup data with 2 criteria: this layout <tbody> year name score 2017 johny 100 2017 andy 150 2017 mike 200 2018 johny 300 2018 andy 400 2018 mike 600 </tbody> year 2017--johny ---? 2018 -johny--- ? any help, thanks in advance.. .sst

I have a range B5:R8, and there is command button that inserts a row where at the active cell. I've figured out how to preserve the formatting for the top row B5:R5 but I can't figure out how to format the bottom properly. Currently if you select the last row (R8) and Insert Row, a thick outline...

hi all.. how to make formula to get date excluded weekend/holidays <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px...

hi all... how to modify data like this <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border...

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.

hi all.. would you help me to figure out this problem. i want use formula to solved it.. <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td {...

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

I am using excel 2003 but the boxes are there that offer me the colouring facility? I have produced a number of boxes by using the border style in format cells. There is a box in the border cells page that offers me the chance to colour the border. If I click on it and turn the box red, for...

Hello Friends, I am using the below code ( i found it on the web) to insert a border from Column A to L whenever a value changes in column B. Sub Test() Dim LastRow As Long LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row Dim rng As Range...

I have a sheet that contains ~40 formatting rules. For some reason, when I scroll through the sheet or make changes to cells, cells that are filled white with no border -> show their borders. Sheet with conditional Formatting Bug: https://imgur.com/O5y4t4g Sheet with appropriate formatting...

Hi Excel Guru's, I am having trouble with html borders when the email is read via gMail (Outlook/Apple Mail Client both read it). I googled and there wasn't much info, other than someone suggesting I change the .BodyFormat = 2 (or 'olFormatHTML)...which didn't work :( Please help me figure this...

I keep getting it to work in little chunks. As soon as I try to make it loop, I get errors. Assumptions: 1 workbook Varying # of sheets Varying # of charts on some (but not all) sheets Some, but not all, charts are column bar charts Goal: Procedure that goes through all the charts, on all the...

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

Hello All, I appologize in advance that I am COMPLETELY NEW to VBA - with no real knowledge. I just finished creating a spreadsheet (sheet name is "Production Sheet") that i am in the process of creating a userform for. I had everything formatted as I liked, but came across an issue when the...

Hi Guys im after some code that can add a border to the end of the change in data but defined by a specific column. so in theory it would open a message box to determine the column to look down and at the end of each change in data insert a border. The border would be from A:N for example I've...

I have a sheet that when I enter the letter B in column A I need the top border for that row to be bold from column A to column AL. Thanks for your help as always.

hi all... how to adding mark "-" between number from 2 columns (joined) this layout : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td {...

Hi All, I want to make a yearly attendance sheet. From the below table I need the formulas for followed conditions. 1. Every month Casual leaves should be added (2 casual leaves every month) based on Month into Casual L colomn. Example: for Jan-19 K3 should be 2 based on today date. 2. 2019...

Good afternoon, I have data that is pulled from a program that has different headers but those headers are alike. For example Bereavement Immed and Bereave Near Relativ they are one in same. I need to sum and consolidate those to 1 field. Personal w/Approval and Personal W/OApproval are one in...