border

Hi, I'm using conditional formatting and for all of the ones I have used (equal to and contains) when i removed the text it leaves behind a half border like so: It stays there unless I go into the formula line and press enter. I would like it if it doesn't do that. Does anyone have any tips...

This might be a silly question , but i am not able to add a border between a Row, Here I Want to Add a Line Between two dates(Where i have highlighted with red color) Please Guide Me on the Issue. Thanks

Hi all, I have a table that looks like this: Whenever I try to remove the borders, I am left with 2 possibilities: Either the border is removed and I am left with a white border (rather than a full green box) where the old border was, or (most common) the cells are merged into one big green...

Hi Everyone :) I am experiencing an issue with a macro I created to help format some raw data sheets I have to deal with at work. The macro I have made is almost perfect, except I need the macro to detect the data range of the cells in use (as this changes with each RAW data file I receive) and...

Hello everybody, I am currently sitting with the following material overview file in Excel: I have made some conditional formatting so whenever I enter a number in column E the entire row gets highlighted. Unfortunately, this erases/makes invisible my dark gridlines/borders from before...

Hello, I am trying to add a button that will edit the row under the last row with values. I am having difficulty with adding a border around Cell (SubNewRow,2). Also, if i wanted to span this border on SubNewrow from column B to M how would I write that? Thanks. Private Sub...

I am trying to count areas with a formula. Please see below. Thanks in advance! <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...

I am trying to count Asterisks in my data but to no avail. <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 ; }...

Hello i try to find most match row # in a array formula i have 2 sheet with same coloms name like i post down i make a formula like Po sheet 1 = all PO row in sheet 2 and qty sheet 1=all Qty in sheet 2 and its give me true and fales in array so i want to get the row # of whre most true like row...

I not sure if it possible? VBA draw table line border every 18 count from col T to AF <tbody> COL T COL U COL V COL W COL X COL Y COL Z COL AA COL AB COL AC COL AD COL AE COL AF ROW1 A B C D E F F G H A D D G ROW2 1 2 3 4 5 6 7 ROW3 12 10 19 ROW4 1 2 3 7...

I'm writing some code where each result needs the colour changing and the border setting. The colour is fine as it's only 1 extra line of code however the border is a few. With rng.Borders .LineStyle = xlContinuous .Color = vbRed .Weight = xlThin End With Is there a...

<tbody> I need help with borders on this spreadsheet. This is a combination of several spreadsheets which I didn't build. This has 6 set columns. Each numbered task may contain 1 to 6 rows. I need to place a border around EACH task. There is data in column A for each task. Is it possible to...

hi all.. how to make sort from small number : <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...

Hi Team, I have a Pivot Table report linked up to a data model held in the Power BI Service. OLAP is used for fast querying. I now need to present some of the data in a slightly different way and I'm wondering if MDX (in Excel) might be the solution. Below is small example to try to...

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

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

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!

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?

hi all.. how to clustering this number below then convert in "model" like 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 {...

I am trying to create a printable golf scorecard. I would like to have the cells for holes where the hole handicap, row 2, are equal to or less than the players handicap, column c, to be yellow with a diagonal border, from lower left to upper right, so that the gross and net scores can be...