formatting

  1. R

    Display wrapped cell into outlook E-mail

    I can't find the answer anywhere. I have an automated E-mail template. In one of my cells there is text that is wrapped. I want it to display that way in my E-mail. This is my current code. Its cell C4 I want displayed properly. Sub Email1() ' Working in Office 2000-2016 Dim OutApp As...
  2. E

    Box parts of text within cell

    I would like to box parts of text within a cell. I know it is possible to format the font of partial cell contents but is it possible to box it. I have attached a picture of what i would like but in just one cell. using Office 365
  3. K

    Xlookup currency/date format

    Hi, I am using xlookup to pull some information from another sheet in the same workbook. The 'return array' is formatted as currency (not sure if this matters), but its not pulling as currency. Its pulling as a general number, but when attempting to format the destination cell to currency it...
  4. D

    Adding images in table with formatting into Outlook using a file picker

    I have pieced together some code using excel as a file picker to add images to embed within subject body. Everything is working just fine with basic alignment, but I would like to get some help adding these images into a table with a specific formatting Outlook seems not to have a huge support...
  5. L

    Data formatting issue

    Hello I have 7 columns of data spanning 3077 rows and I have concenated it to one column to read as an address with phone number and website..each of these having a title in the concenate formula. I need to transfer this data to a CVS form to upload into a map however when I try it reads data as...
  6. Jyggalag

    Can somebody help me test my VBA code and fix it if it does not work?

    Hi all, I have this VBA code to write an email body text: eBody = "Dear person," & "<BR><BR>" eBody = eBody & " 1Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text (Text text...
  7. T

    Change horizontal axis to first day of the month

    AXIS values I'm hoping someone can assist. I have a bar chart and want the horizontal access lines to represent first day of each month. When I right click horizontal axis to format axis, I don't have the option to change min & max bounds to dates/months as in start 01/10/21, and end 30/06/22...
  8. C

    VBA copy formatting from one sheet and paste in another sheet

    I need some VBA to do the formatting auto 5 Sheets 1st sheet formatting template other 4 Q1 / Q2 / Q3 / Q4 Button needs to be on each of the Q's, need to copy formatting from formatting template and paste it from A2 down to last row with data Formatting on formatting template Q1 is from B2...
  9. A

    Trouble getting conditional formatting to work

    Hey again guys, I've got some really good help in another thread but there are unfortunately a few more questions I have regarding excel. I'm getting a little stressed because I've only 2 weeks to finish a school project and in times like this I just wish I picked up Excel and learned it...
  10. Ruts

    Updating Text Format in a Shape using VBA

    Hey everyone, I wrote this bit of vba quite some time ago (2017) to run a little bingo caller for a social team where I was - keeping excel up to date wasn't something they were good at - so the version at the time worked. They have now updated to O365 and the reformatting of the text in the...
  11. K

    Custom Sort on Pivot Chart

    Hello! I have a simple pivot chart collating some totals for figures in each month of the year. I would like this to display in the month order (Jan-Feb) but I am unable to manipulate the source data so it reflects this. Is there another way to do so? I do not have an option to use the custom...
  12. L

    Highlight 3 duplicates occurring within 3 days time

    I'm looking for a best way, most likely via Conditional Formatting, to highlight 3 reoccurring from B within 3 days time frame from A I've managed so far to get 3 reoccurring but for just 1 day So, all those 4 rows with PC should be highlighted, not just 3 of them Hope you can help
  13. T

    Need short Macro for formatting task

    THANK YOU SO MUCH FOR ANY TIME AND EFFORT IN HELPING ME SAVE MANY MAN HOURS AT WORK!!!! I just need to take a large data set from the first format below to the second. The changes include: 1. New column 2. Each row from the original data set that begins with cell A containing "RE: $...
  14. M

    Macro to edit cell values and copy/paste

    Hi all, Thank you in advance. I'm very new to VBA/macros and I think I have a relatively easy task to complete, but I can't seem to figure it out. I received a bunch of UTMs for salmon redds, but in the wrong format and need to use a batch converter to change them to Lat/Longs in order to import...
  15. R

    Excel Pie Chart Formatting Inquiry - Trying To Remove Gray Line Within Pie Chart

    I'm building Pie Charts for a client at work and they are asking me to try and remove the Gray Line that goes through the middle of my Pie Charts. I've included the data set for reference. As you can see, only the 'Lab' User Group has any value in the SF column. Despite only the 'Lab' User...
  16. A

    Add a line after each unique value

    Hello all, I am trying to figure out how to separate some values on my spreadsheet, and I can't seem to think of any effective way to write some vba code to do this automatically. In Column A (starting from row 2 until the end of data), I have some values. "Secured", "Unsecured", "7A"... They...
  17. J

    Concatenate cells but keep formatting of text from source cells

    I have been trying to concatenate cells from a different master sheet into one cell for a label. the problem is that some parts of the text are bold (for allergens) and when I finish it erases all the formatting from original cell. I've tried several different macros and nothing works. Please...
  18. F

    Help with Conditional Formatting

    Hey guys. I've attached a portion of a spreadsheet I'm hoping to get help on. In cell E6 I would enter the time a particular incident was created. I'm looking to use conditional formatting to turn that cell red if the incident runs longer than 9 hours. Cell A3 has the =NOW() formula in it...
  19. ChloeLM

    Efficient formatting of specific cells by looping through...

    Hello everyone I'm a VBA novice who has muddled through a piece of code and got it working. However it's very long (and slow!) and i'm looking for some advice on how to make it more elegant (and efficient!) in order to speed up my procedure. Am i using an efficient way to loop through the...
  20. M

    Line graph - change colour if number decreases

    Good afternoon, I have some data already in a combo chart, a mixture of stacked columns and a line. The data for the line predominantly goes up in order, e.g. 1,2,3,4,5 However their may be some instances where the data will decrease, e.g. 1,2,3,2,1 I would like the line for the data where...
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