border

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

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

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

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

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

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

hi all.... how to make series like this : <tbody> data expected result jack 1 2 3 cat 1 dog 1 etc.. </tbody> note : without helper column any helps...greatly appreciated... susanto.

Hello, <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 ; }...

good afternoon, i hope there is someone who can solve this excel problem i have. As I admin assistant one of my many jobs is to amend worksheets to the 'Business' format/style.... rows height = 20 column width = 14 font = Calibri font size = 14 although I have a macro to do the above...

Hello! I would like to write a macro that puts a top border on every fourth cell in column D. Sheet name: "MISC" and no header. Any Suggestions?

Hi all, Could someone help me to amend the below code? I use the below code on as part of copying varies results to a new tab and applying a border. Some of these extracts have 5 columns some have 10 so i used A2:Z... but obviously this borders all cells from A:Z. I want the code to only...

I have a table with account codes in column A. The accounts are 4 digits between 1000-9000. But not all accounts are used After Account 3999 I want to insert a thick border underline in that row. I want to develop a macro which can identify which row is below account 3999 and insert a thick...

Good afternoon, Please see data below. I am looking for some VBA code that will highlight an area if it does not have a value in it. In Column E if the first 2 Alpha characters do not start with "MA" or "EN" then highlight the area, if not leave blank. <style type="text/css">...

To All: I am trying to create a bottom border only. I am using this VBA script (found on this site). But, am getting borders on all edges. I am only wanting border on the bottom. Dim LR As Long LR = Range("A" & Rows.Count).End(xlUp).Row Range("A2:Z" & LR).Borders.Weight = xlMedium In my...

Hello, I'll start by saying I'm a noob when it comes to VBA coding in excel, but I'm trying to learn. Hoping you guys could help me code a toggle button. When the button is depressed I would like the font, fill color, and border to be white in rows 23-35, on that worksheert, so it is not...

Hello, I'm trying to add an outside border to a range of cells that starts at a constant cell (A7), but extends down a variable number of rows and across a variable number of columns. The Excel spreadsheet will be different in terms of rows & columns each day, so I want to add this part to my...

I can set a border with: Dim rnge3 as Range Dim rowstart as Integer, rowend as Integer set rnge3 = Worksheets(3).Range("A" & rowstart & ":AU" & rowend) With rnge3.Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = 3 End With But when I want to clear that...

I have about 150,000 rows of data. What I am looking to do is to pull out the currency to the cell next to it. The data is formatted like below: Please help. Thanks again! <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ...

Hi Team, Looking to replicate the following in DAX... Here's an example table in Excel to paint the picture: <tbody> Key Figure UOM Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Average Weight PUMs 4,011,692 4,186,301 3,610,294 3,413,225...

Does anyone have attractive slicer formats they'd like to share? I'm tired of the basics but creating an eye-catching alternative takes a lot of time, and of course they don't easily transfer to another worksheet. To start the ball rolling I've got VBA for one. Someone gave the design on a...