formatting

  1. G

    Conditional format based on Cell header being between timeframes

    Hi, Been a while since I've been stumped, and I'm sure its easier than I'm making it out to be I want to highlight the cells C2:H5 based on if the row header is within the time range A:B relative to the row of coarse Any help would be great, i know i ts a conditional formation by...
  2. E

    Add row to table copying formatting

    Hi, Very grateful for anyone's help or advice! I have a table called "CR_Table" - I'm looking to add some VBA code to insert a row to the bottom of the table when I click on a button, copying the formatting/ formula from above. Please could anyone let me know what code would help me do this...
  3. S

    Phone Numbers not all aligning to the right

    I have a list of phone numbers in my excel sheet. I formatted them using Special and Phone Number to get (250)999-2222 Format. Weirdly some align left and some right? (Not sure this has any bearing but cells with no phone number are marked None. )Please advise. Thank you in advance.
  4. M

    Insert merged row into Excel, with duplication of the row(s) formatting above, using Command Button

    Hello there! I'm an enthusiastic if incredibly amateur Excel user- I usually just use google to figure things out but I'm hitting walls with this issue, so thank you in advance for any support or help you can offer! I'm trying to build a feature into an Excel sheet, so that if you click on a...
  5. D

    Highlight cell if date has passed

    I know this seems simple but I've been researching this for a few hours and I'm come up blank. I'm looking to do the following two things with conditional formatting. I need a cell in Row B to go RED if the planned end date has passed and YELLOW if the planned end date is within 14 days of the...
  6. D

    Enter specific formulated data - numbers & letters with dashes

    I am working on a shared spreadsheet for tracking and I need users to ONLY be able to enter a value that is LLNNNNN-NN (letters and numbers) and in another column (different data) LNNNNNNN-NN. Both are combos of letters and numbers but I need users to only be able to enter it in these ways. For...
  7. H

    Applying conditional formatting to all tables

    Hi everyone, I’m new to this forum / VBA and I’m trying to create a code that applies conditional formatting for all columns in every pivot table and refreshes every table in my Excel workbook. I’ve been able to set this up for one pivot table / one sheet but I’m not sure how to change my code...
  8. M

    Pivot Table Date Filters not formatting correctly

    Using Excel 365 I have a data set that contains a "month" column formatted to "MMM-YY". When I pull this column into the filters section of my pivot table, the options are: "<29/02/2016 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec >01/07/2023" How do I get it to show my desired...
  9. M

    Sorting data in a macro messes up formatting

    As part of a macro to prepare client ready files, a tab with various tables of data of varying sizes gets filtered to show empty rows and these rows are then deleted. This is done using the following code: Range("A2:A" & Range("A" & Rows.Count).End(xlUp).row).AutoFilter Field:=1...
  10. Saher Naji

    Change color of cell to Yellow once I copy it

    Hello, I'm trying to use this code to change the background color of a cell to yellow when I press Ctrl+C and has it stay yellow. This should be applied to every cell I copy. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Application.CutCopyMode = xlCopy Then...
  11. S

    forcing to enter a specific format of numbers and symbols in a cell

    I am looking for a way - preferably hidden in the sheet as a macro - to force users to enter a specific format for latitude and longitude (2 different cells) The format must be: 00-00.0 N/S - where the 1st 2 digits max 90 separated by - and then a max of 99 separated by . [not comma] and the...
  12. B

    Conditional formatting the number format of a chart

    Hi all, I'm trying to find a solution for a chart in PowerPoint, but I assume that if there's a way to do it in Excel it would also be applicable to my query. I'm trying to achieve the following. I have a column chart and I want to force it to show only the values <3% with 1 decimal place, and...
  13. H

    Assigning values to cells in one column based on the values of 2 other columns, please help!

    (Using Excel on Windows with a 365 subscription) I have 4 columns. Column A is store name (Jim's or Jane's). Column B lists the date (each date from 1/1/2020 to 12/31/2020 repeated 24 times) Column C lists the hour (so hours 1-24 for 1/1, hours 1-24 for 1/2, and so on for all dates of the year...
  14. R

    Color cells if workday and holiday (VBA)

    Hello, I got a macro button which adds month sheets for a specific year that is entered in an inputbox. The following code unsuccessfully attempts to fill all working days with a pink colour if they match a range of cells that represent the holidays (and include blank cells). Is there a way to...
  15. J

    Subtotal of Sum of Hours and Not Count

    Excel Version = 365 OS = Windows Hi Everybody, Still New to the whole Power Pivot thing so please bare with me as I will have a lot of Obvious Questions that might seem stupid. Summary: I have Engineers that work on Work Orders, Each Work Order has a Start Date, Start Time and a End Date...
  16. C

    VBA Help - Keep Format of Referenced Cells When Using "IF" Formula

    Hey all, I've scoured the forums and I cannot seem to find an answer to what I'm looking for. Right now, I have a workbook that contains multiple sheets. The first sheet has a drop down menu where you select a specific option. Then in the cell next to it, I have an IF formula that will...
  17. N

    Conditional Formatting - Extend 2-color Gradient to Adjacent Columns

    I would appreciate help with extending a 2-color gradient that is based on a percentage column to the adjacent columns. Attached is an example. The actual spreadsheet has many more rows so it's not practical to do manually. Thank you.
  18. J

    Preparation for importing multiple word documents to excel

    I have multiple word documents (over 200 individual word files), that I need to import to an excel spreadsheet. The excel sheet is already populated with specific fields (columns) that the data from the word documents needs to be mapped to. However, the word file is not really prepared in any...
  19. K

    How to format Listbox Columns as Currency in Excel

    Hi I've just started using a ListBox in Excel to view a table from one sheet on another. I've been able to do this using very simple code as Private Sub UserForm_Initialize() Me.ListBox1.List = Worksheets("Cashflows").Range("A4:H26").Value End Sub However, as this does not include...
  20. G

    Copy and paste macro can’t remove formatting.

    Hello, I’m very new to excel macro's What I am trying to do is take Info from a BOM with Reference, Value and Part numbers from sheet1 and move the data into sheet2 that I can then use to print a sticker. when I run my macro it opens a search box, I search for a unique part value then it...

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
Back
Top