border

  1. muhammad susanto

    Convert Text to Real Number

    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 {...
  2. 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...
  3. M

    Can I colour borders ?

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

    Insert Border When A Value Changes

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

    Conditional Formatting Bug: Borders show on cells formatted to be filled white + no Border

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

    HTML table borders not displaying in GMAIL (only)

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

    Procedure to add border around all data points, on all charts, on all sheets of a workbook?

    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...
  8. 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...
  9. R

    VBA for Conditional Formatting (Borders) and Center Across Selection

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

    Code to select column and insert border at each change in data

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

    Code Help Needed-Make Top Border Bold when entering a letter in a cell

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

    Adding Mark "-" Between Number from 2 columns

    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 {...
  13. K

    Yearly attendance sheet_Need help

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

    VBA Consolidate Headers to 1 Column

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

    Sumproduct

    Hi, I have a file that I do a summary about different items (SKU) for a given entity for the current period (February in this case) and a YTD. For the monthly one, the formula is a sumproduct based on the entity, SKU and period (201902). Is it possible to have one that's cumulative? For now I...
  16. W

    Pivottable formatting - borders based on first item in "Column" section

    Hi All, I have a pivottable with multiple items in the column section. I have tried modifying the pivottable using the Pivottable styles editor but can't seem to get what I want to achieve to work and would appreciate any advice I have put a picture below with two examples (with made up data)...
  17. S

    VBA for Unique Count

    Good evening, I am looking for VBA to do some unique counting for me. I have over 200000 rows of data. The formula approach I have been using is below. But I really want to automate to VBA. {=SUM(IF(FREQUENCY(IF(($A$2:$A$22=F2),$B$2:$B$22),$B$2:$B$22)>=1,1))} <style type="text/css">...
  18. D

    My border won't appear

    My border won't appear. What setting do I need to change to get a border appearing?
  19. M

    Data set comparison... what's the best method?

    Hi Team, Looking to understand how others would tackle the following task... Here's a very simple example of my data set: <tbody> Version Month Forecast A Jan 10 A Feb 3 A Mar 8 A Apr 5 A May 3 A Jun 7 A Jul 8 A Aug 1 A Sep 10 A Oct 9 A Nov 3 A Dec 4 B Jan 4 B Feb...
  20. J

    Formatted border to follow contents when sorted

    I've highlighted certain cells with a Thick Outside Border and have the cells colored. When I sort the sheet the data and the color move but the Thick Outside Border remains fixed. how do I get the border highlighting to move with the data? thanks

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