border

  1. S

    Count Areas with a formula

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

    Counting Asterisks

    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 ; }...
  3. A

    Find most match row #

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

    VBA draw table line borders every 18 count

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

    Declare cell / border format to be reused

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

    If cell contains data then format

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

    Automatic Sort Number From Small

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

    Can MDX be used for this?

    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...
  9. 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...
  10. 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...
  11. 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!
  12. 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?
  13. muhammad susanto

    Clustering Number Then Convert in "Model"

    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 {...
  14. T

    Conditionally Adding Diagonal Border and Fill Color

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

    VBA highest grade per row

    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 ; }...
  16. muhammad susanto

    Vlookup with 2 Criterias

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

    Formatting a Dynamic Bottom Row

    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...
  18. muhammad susanto

    Counting Date Excluded Weekend

    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...
  19. muhammad susanto

    Delete (.) Then Combine 3 Last Number With Mark (-)

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

Some videos you may like

This Week's Hot Topics

Top