format

  1. N

    Macro to insert 2 empty rows and row of heading after subtotal row

    Hello, I would like to create a macro, which will insert a subtotal after each change in either column B (Employment Status) or C (Type of Leave), bold the entire subtotal row, change the background of the subtotal row to grey, insert 3 rows after the subtotal and insert a line of headers...
  2. R

    Conditional Formatting and Percentages

    Hi All, I have a spreadsheet which, in column L there is a percentage that is based on the numbers in columns D and G. I would like to create a conditional format that says: -if column L is less than or equal to 3% format the entire row green -if column L is between 4 and 6% format the entire...
  3. T

    Excel date vba filter

    Hi guys, Been stuck on this for days now so I'm resorting to asking for assistance on this one. I'm trying to filter between two dates in dd/mm/yyyy format ( my PC is formatted this way too in regional settings), but after I run the code, the date "custom filter" has mixed up the days and...
  4. S

    Format text between two bookmarks in word (VBA)

    Hello, i hope you all are well. I am looking for a way to format text (e.g. size, fond and line spacing) between two bookmarks ("Start" and "End") of a word document using VBA. Do you have ideas / tips how i can solve this problem? Thanks in Advance and best regards, Sarah
  5. C

    VBA - Copy Cell Formatting to Conditional Formatting of Range

    I have a number of reference cells representing the working duty names an employee may be rostered to work. (e.g L, B, AD, OH, AL, etc.) These cells are static and used as a reference for available duty names but are also coloured & formatted (including bold, italics, etc.) to allow them to...
  6. B

    Format decimal as number of months

    Hey everyone, I want to format a decimal/fraction as a number of months. For example, I'd like to enter "=1/12" into a cell and have it show "1 month," or enter "=1.5/12" and have it show "1.5 months." Is this possible? Thanks!
  7. S

    hh:mm:ss average problem

    hello, I have data that present at hh:mm:ss eg 00:01:52 but when I try to average I get the DIV error and when I try to sum it comes out as 00:00:00 I have tried the different formatting but nothing changes.
  8. R

    Chart Formatting VBA

    I have a chart labeled "Time Spent versus time allocated" and it has a code that will update the chart when new data is entered. However from looking at the bar chart you can see that the formatting of the bars and the labels are not quite right. Any idea of how i can set the formatting...
  9. J

    ActiveX Input Format as currency with 2dp

    Hi All, I have been trawling the web and Mr Excel for an answer, but everything I have tried doesn't work. I am creating a userform that users need to be able to add in monetary values. Below is how I have the textbox set up at the moment, but it's not doing what I want: Private Sub...
  10. Thumper007

    Formatting on a list Dropdown

    Good Afternoon all, I have a list that contains 3 options. Watch option is a statement. I want to highlight a specific word in each statement and then on another tab, be able to select the statement from a dropdown and have the statement come over with the word still highlighted. Is this possible?
  11. M

    VBA - Need help formatting a row range based on string or format in column A

    I have the code below that works. It searches column A looking for "00" as the left most characters and then formats that cell with white text and black interior. Dim cel As Range For Each cel In Range("A6:A300") If Left(cel.Value, 2) = "00" Then cel.Font.Color = vbWhite cel.Interior.Color =...
  12. H

    VBA to format sheet

    Hello Excel users, My requirement is to format the existing input sheet where name is to be aligned with other records.Expected output should be in this format I can very well do this Power Query but now i need to do this in VBA. Can any one let me know how to use VBA code for this requirement?
  13. O

    Field Type Amendment

    Morning, If I amend a field format in the source Excel document, will Power BI be able to refresh the data without errors? Basically I've got a data download from another system and the financial values were stored as text and I need to change them to decimal for a SUM but query editor can't...
  14. A

    Formatting 2 strings in cell in different ways

    I have 2 columns, Column A has a regularly formatted first name. Calibri 11. It is also a look up formula from another sheet. Column B is Surname which is also a lookup formula from another sheet but I have used the Upper function on it to make it all upper case and also bolded the column. I...
  15. K

    Format Month Number Variable as mm ?

    I am writing a script that will save files to a new monthly directory for 3 months in advance. Directory naming convention is this: 04-April 2020 I can get the year and I can get the month name. I can get the month number to return 4, but I need 04. FY = Year(Date) FM =...
  16. R

    Error on number formatting on VBA - Very Strange...

    1) I have an excel sheet with values (Numbers) that represent dollar amounts. 2) I have a Userform that has labels that update the values according to the amounts on the Excel Sheet... Everything was running smoothly until I opened the excel worksheet with a PC (I work on MAC Excel 2011) in...
  17. M

    Force users to save as .xlsm or pdf only

    Hello everyone, This thread is related and inspired on an old one: Force users to save as .xlsm or xltm only. In any case, I tried to replicate the code for XLSM and PDF format only. No luck. Although the two options are available, the PDF one didn't produce any good file. I would like to...
  18. C

    Table column with date field

    I have a table created with one empty row at the start and one of the columns is a date in the format dd/mm/yyyy When a user inputs data and tabs down to create a new row the date column reverts back to mm/dd/yyyy Is there a reason for this even though I have set the format of the initial row...
  19. A

    Dates show DMY in cell, but MDY in formula bar - won't sort or convert

    Hello - I'm using O365 in the US but have system time on my PC set for Australia (in case this matters…) WorkSheet #1 I have received two excel worksheets, one has dates formatted in DMY, and if I switch the formatting of any of those cells to General, I see that the resulting number (in...
  20. K

    Query Editor - Issue with coverting date format when year changes when date format is Day DD MMM e.g Sat 28 Dec

    https://imgur.com/a/2bFUSl2 At the switch over to 2020 it just shows as an error using the following #"Changed Type" =Table.TransformColumnTypes(Data0,{{"Column1", type date}, Is there an way to handle this?

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top