border

  1. C

    weird line visible in the text box

    Hi all, I'm using excel 2016, and when I create a text box and fill the box with background color, towards the right of the text box there is an awkward line (it's not the border). It's in every text box I create and fill, and the line is always about 0.8mm from the right border of the...
  2. A

    destination paste to Table >>ONLY VALUE

    hi when i press save button , my value pastet to sheet "data" With border i want past to data sheet without any border , just value download file : https://ufile.io/ql5uk Sub Rectangle2_Click() z1 = Range("B5").End(xlDown).Row z2 = Sheets("Data").Cells(Sheets("Data").Rows.Count...
  3. J

    VBA loop for next

    In Column B is a concequtive list of numbers from 1000000 to 7000000. Want to insert a underline border in column A to H the first time the number is above 3999999. (This is part of a vba formatting mode) Column B is a list of account numbers. Not sure the specific account 3.999.999 exists...
  4. W

    Formula Required to Group Family Members, where ID matches

    <style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 10pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Georgia, sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { font-family...
  5. 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...
  6. muhammad susanto

    Rank From Number

    hi all... how to make rank this layout below : <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...
  7. Y

    Excel Online doesn't show some Borders.

    Hey, So basically I have an excel-workbook where the background is colored light grey and there is a table with "normal" black borders and one thick black border under the top row. When viewing/editing the file in Excel (offline) everthing looks like it should, but in Excel Online some of the...
  8. muhammad susanto

    Insert 3 Number Zero (000)

    hi all.. how to inserted 3 number zero (000) in a 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...
  9. S

    "Highlight" a radio button's text.

    Hi Guys! This one should be easy, but I'm just going round in circles trying to fix a simple problem. I have a Form, on which is a Frame within which are four radio buttons with their associated texts. When the Form is Initialised, I'd like the second radio button to be set. Using the following...
  10. muhammad susanto

    Extract Data After Last Space

    hi all.. how to extract data below after last spaces 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...
  11. D

    adding border line after the same id number

    <tbody> ID number B C D E F 1 109094 2 109094 3 148877 4 148877 5 154470 6 154470 7 154470 8 154470 9 183357 </tbody> I have 566 row and more than 10 columns I have multiple id numbers. I want to...
  12. muhammad susanto

    Fill Series Number Based On Adjacent Cell or Column

    hi all... how to make fill series number based on adjacent column 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 { padding: 4px; margin: 3px; border: 1px...
  13. muhammad susanto

    Counting in Different Data Repeated

    hi all.... how to counting data this below , different name 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 { padding: 4px; margin: 3px; border: 1px solid...
  14. N

    Time and Date Sum w/ auto filter

    I have a vacation tracker for work, that always me to see when people start and return from vacation or other time off situations. The issue that I am having is two parts. Main one: I have figured out how to calculate the days between days by using b2-a1, but I have to incorporate the times. So...
  15. S

    Border around picture won't go away

    Hi Excel group, I have a sheet that the border will not go away even when I select format, no outline. It's a light gray box. The background is white so it stands out. I used name manager and set up a formula, then inserted a picture and assigned the picture to the name that i created. The...
  16. A

    Sumifs Help - Payroll Planning

    See the table below, I'm looking to calculate available hours in Col D. the SUMIF statements for the FT and PT statuses are straightforward. Looking for help on the date conditional in regards to 'Seas' Status. If the status is 'Seas' I want their Hrs Avl added to the total Available hours...
  17. muhammad susanto

    Sorting Data Not Work

    hello all.. i try to sort data asc to desc but not working , how to fixed it.. <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...
  18. muhammad susanto

    Lookup From Partial Number (From Left)

    hi all... how to lookup data with partial match count of number 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: 1px solid...
  19. muhammad susanto

    Custom Number Format (2.01.01.03.02.2)

    hi all.. how to make this layout using Custom Number Format : <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 ; }...
  20. M

    Data Forecast

    Hello Everyone, I have a scenario wherein I need to know the forecast based on the previous year data. <tbody> Jan.'17 Feb.'17 Mar.'17 Apr.'17 May.'17 Jun.'17 Jul.'17 Aug.'17 Sep.'17 Oct.'17 Nov.'17 Dec.'17 Data 1203 1344 861 1132 1344 1142 900 1706 1552 3002 1358 1367...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top