format

  1. Jyggalag

    Create slicer for a list without pivot table?

    Hi all, I currently have a list that looks like this (albeit much much much larger in reality): I would like to create a slicer for column D (Height (CM)). However, my table is not a pivot table. Does anybody know how to do this? I read online that I have to go into the design tab and do it...
  2. S

    VBA to format left header specific text

    I wanna change the font and size of the entire left header and make part of that header Bold. Since this doesn't have a cell reference I'm having difficulty trying to figure out how to do this. Advance Thanks for all the answers. Note that the header info is being fed in using a userform to get...
  3. R

    Format copying not working

    This is my full code Sub StripData() Call InsertData Call FormatData 'Call DragData End Sub Sub InsertData() Dim myWb As Workbook Dim myRowsToCopy As Range Set wbtemplate = Workbooks("Template.xlsm").Worksheets("Raw") Set formatrange = Range("B2:CE2") Set formularange = Range("AK2:CE2")...
  4. D

    Format power bi matrix

    Hello, Can someone point me in the right direction for applying data bars to a bi matrix, it seems like I've been through every drop down menu ; Grid , Values, etc and I can't see anything, I've looked at one or two things online but they seem to be out of date as the menu's are not the same as...
  5. D

    VBA remove margin before bulletpoint/unordered list in email

    Hello! I am using VBA to send out emails containing a text body made up of bullet points with varying lengths (using the code from smozgur in this thread: Use VBA to enter a varying range of bullet points into body of email). Which creates a reference to the bullet list in the body text instead...
  6. E

    Textjoin dates and ignoring blanks

    Hello, I'm trying to use the textjoin function to combine multiple dates into one cell and ignore blank cell. I was able to get to work using this function =TEXTJOIN(",",TRUE,D8:P8) but it brough the dates over in a number format like 44655, 44683, 44718. I want it to look like this 4/4/22...
  7. D

    VBA change the format of a cell from account to custom %

    Hello, i was curious if there is a way to use VBA to change to format of a cell(s) from accounting to custom type 0% Saying i have a sheet 1, cell D15 and D16 these are both accounting but wanting them to change from that to custom 0% thank you!
  8. A

    Covert Data into Text with VBA Code

    Hello, so when I download this sheet from the web, it always shows this error "Convert to number", basically in few of columns (where there are numbers) it is stored as different format which does not allow you to sort with number and mathematical operations, I change it manually with...
  9. E

    Increase/Decrease Decimal stopped working

    So since friday my excel is acting up. If i try to decrease/ increase decimal this happens If i try to change a cell from general to number it instead moves the decimal point two steps 1.234>>0.01, 12.34>>0.12 etc. If i change my system comma separator from dot to comma everything starts...
  10. M

    Redesign excel format

    I have the following spreadsheet with about 2000 rows, ABCDEFGHIJKLMNO1Ref No(s)TitleEff DateATAComments2TEST 1B737 ADVERTISING PLACARD INSTALLATION25Referenced By: TEST3ParagraphMethod Of ComplianceRLifeLast ComplE/D O/RideLimit/ IntervalF/ LNext DueRemain4Initial Issue...
  11. M

    Conditional format not working when pasting values

    I have a sheet with various conditional formats, I have noticed sometimes when copying value only into the work sheet that sometimes the conditional formats work instantly and some times i have to click into the cell and click back out to get it to pop. is there something I can do to get them...
  12. Jyggalag

    Merge cells of emails into one cell - possible?

    Hi all, I have the following setup (albeit in a much larger setting with multiple lines of emails): I want to merge my emails in A121 and A122 into one cell, like I have done above in A120. Is this possible? In reality, I need to do this for about 50-100 rows of emails from column B-T...
  13. X

    HELP - Dashboard Objects are Randomly Resizing on a Data Refresh!

    Hey everyone, I don't use Excel a lot, so I am quite proud with what I have come up with. Wish I could share it but it has all my financial data and crypto holdings to create a dashboard. Power queries, just trying to solve a different issue at the moment with VBA, the lot! Besides the...
  14. T

    Highlight multiple cells based on value of one specific cell

    Hello, I am trying to Highlight multiple cells based on a specific cell. If cell K32 = True, I want cells B2:G239 highlighted in one color and if K32 = False, then no change. I have tried the following with no luck: Thanks in advance for any assistance!
  15. A

    how to copy cell value from one sheet to another with the same formatting

    hello, community. I'm trying for 2-3 days to make a Microsoft Access Database for a schedule at my work - 24/7 x6 people. it's too hard for me and I'm back to excel. at the moment I'm trying to bring the information (text) from sheet 2 to sheet 1 but i want to keep the text formatting ( only...
  16. M

    How does one avoid differences in users keyboard language when using the Format command(VBA)?

    Hey hey people. I need to use the Format function to change some raw numbers like "123456789.123456789" to either be "123,456,789" or "123.456.789", depending on the language a user selects when activating my macro. I found some code online from Formatting Numbers in Excel VBA - Automate Excel...
  17. M

    Format cells based on row and column references

    Hello, I have a file with 2 sheets Named: Holiday Calendar ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ120222BHBank Holiday UK&IBHBank Holiday UKBHBank Holiday IrelandHoliday34January5Carried FwdIn LieuEntitledLeft...
  18. E

    VBA to turn part of text in cell red if negative

    I have a column that the user wishes to have a simple calculation (H11-M11) as well as having a % in the same cell. Formula is ::: =(H11-M11)&" / "&TEXT(H11/M11,"0%") If the first part is negative, I wish for it to be RED. If not, then GREEN. Does someone know of a code that allows this...
  19. E

    Some Cells After MS Query Table Refreshed Have to Be Clicked before Formatting Works

    Hello all. I have a situation that is driving me crazy. First off, I am using excel in Office 365. I have a workbook in which I export data out of SAS tables into different sheets. I have a main sheet where I use MS Queries to pull that data in from the other worksheets in the workbook. I...
  20. P

    VBA Formula to paste cell value into active cell then change it's color and add an underline

    I am very new to VBA so I apologize in advance if this question and code is a bit amateurish. The code I currently have is Function CUSTOMSTYLE(TargetCell As Range) TargetCell.Copy ActiveCell.PasteSpecial (xlPasteValues) ActiveCell.Font.Color = RGB(255, 0, 0)...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top