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...
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...
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.
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...
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...
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.
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...
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:
How do I get it to show my desired...
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...
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...
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...
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...
(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...
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...
Excel Version = 365
OS = Windows
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.
I have Engineers that work on Work Orders, Each Work Order has a Start Date, Start Time and a End Date...
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...
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.
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...
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
However, as this does not include...
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...