formatting

  1. M

    Keep source formatting when pasting ranges to a shape

    Hi all I have a workbook with 2 different worksheets. In the first worksheet you type in different information. When clicking on the other worksheet the data from the first worksheet is then copied and pasted into shapes in the second worksheet. I have a challenge of keeping the source...
  2. L

    mm:ss formatting

    Does anyone have a solution to formatting mm:ss without the AM/PM after it. I'm creating a spreadsheet where I need to put time as an input, say for a race where something like 10:30 would be 10 minutes and 30 seconds. There are then some calculations done on the time which says if time is below...
  3. E

    Help with excel formula

    Hi all, I am having issues with the following formula: =COUNTIFS('Raw Data - Travel'!D2:D350,">"&'Total Summary Data - Travel'!B3,'Raw Data - Travel'!D2:D350,"<"&'Total Summary Data - Travel'!C3) Cells B3 & C3 are start and end dates. D2:D350 contains dates. The formula works perfectly...
  4. 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...
  5. freelensia

    Excel: cannot change alignment of a cell under conditional formatting

    Hi, I have a structured table with a certain table style: All of the cells in them are also formatted as "Normal". However my "Normal" is slightly different. It has cell background as white (not no-color), and has alignment OFF. Furthermore, in column Good Listings I have some Conditional...
  6. F

    Best way to automate the reformatting of this?

    I don't know how to best deal with getting my example onto this post, so forgive the copy pasta. Below is an example of how my company's system exports reports in Excel (there is no CSV, or un-formatted option for export). So, the employee's name is sort of randomly inserted at the top of...
  7. T

    Cell format overrules conditional formatting

    I have formatted cells using conditional formatting based on a given value in my workbook being equal to either "EUR" or "USD". The custom format it should get when "EUR" is: "€"#.##0,00 (see screenshot 1). It shows the correct format (see below image), however when you would paste this cell...
  8. D

    Highlight cells with Conditional Formatting using large range of values

    Hello all, this is my first post. I’m having an issue with Conditional Formatting. I work in a warehouse, and I am having issues in a certain section of the warehouse with items being split across several different stock locations rather than being consolidated into 1 or 2 locations. There is...
  9. T

    Automatically copy cell formatting based on the formatting of another cell

    It's easy to copy the value of a cell. If you want to automatically copy the value from A2 to B7, then in B7 you type =A2. But can something like this be done with cell formatting? I use a spreadsheet to track our work, and we color each item based on who is handling it (every person is...
  10. E

    Formatting to last row

    I want to highlight cell b37 and until the last row (which might change) in order to format that range of data this is what i have so far, whereby i have declared at the very start of the code the following: Dim Lastrow as Long originally i had it as range("B37:B150").Select, but i had to...
  11. 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...
  12. K

    Formatting help

    Hi, I have this problem with my excel in general: above sum should be 0. All decimals are exactly 2. Is there something i can correct in the formatting in my excel? Thank you in advance for your help.
  13. H

    XML table / conditional TEXTJOIN function

    Hi I have a system which exports XML files that I need to convert into Excel for reconciliation etc. The XML table function in Excel works but puts each bit of data on the next line - for example: Ref Surname Forename 1 Mouse Mickey 2 Duck...
  14. E

    Conditional formatting on date ranges

    Hi there, I am currently trying to create a dynamic calendar in excel. A disclaimer upfront: my username checks out. This is literally my second day working with excel formulas. I have done some VBA in Word before but that's it. So my idea is to mark certain cells in my calendar in color...
  15. W

    Sum conditional formatted cells

    Hi all, I am trying to sum all of the green cells (see picture @ https://ibb.co/vjVRrBC). Green cells are formatted using a conditional formatting formula rule. The purpose of the formating is to highlight every cells in columns U that I have room for in my budget (C8) starting from the top...
  16. S

    Formatting date question ....

    I have data in columns G & H which is 13/11/2019 (ie, 13th November 2019) I want this date to display as 2019/11/13 When I formal cells > custom and enter the format as yyyy/mm/dd, this looks good. I save (as csv) and reopen the file, but it reverts back to it's original formatting? How do I...
  17. P

    Format Painter Doesn't Work

    (Using both the latest Excel release (2019?) and libraries with legacy releases) I have some music track time lengths that are in the format 5:43 (h:mm), but another column displays 5:43:00 AM. So I used both the Format, Number, Custom, h:mm option on the cells that showed the AM designation...
  18. T

    Applying Conditional Formatting to only the first 10 strings in a cell

    I want to apply color to the first 10 characters in cell B63. It has a formula in the cell. I selected conditional formatting, then New Rule, then Use of formula to determine which cell to format then I entered this formula =LEN($B63)=10. It worked and applied the color to the first 10...
  19. T

    Conditional Formatting

    Is it possible to use conditional formatting to highlight a cell if it is the active cell and how would you do that? Thank you

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top