formatting

I want to Conditional format ONLY THE ONE CELL that contains the lowest value, but only in there is a "1" in the SEL column. For some reason I'm not able to get the correct syntax for the Conditional Formatting formula. In this example I'm working within a table named "data". I want the cell...

Hi, I am trying to format a cell with 2 types of formatting conditions that will display correctly on a chart. For instance if the cell is below 1000 I want it to use the standard number formatting, but if the cell is between 1000 -10000 I need it to look like 2.5k and for anything over 10000 I...

Hello! I use named ranges in charts and VBA to change the named ranges so that I can update hundreds of charts in an automated fashion. Let's assume a have a chart that has series1 named range1 and series2 named range2 and i want to use vba to change this so that series1 references named...

Hello all, I have the following DAX Measure: Total Deplaned Cargo = VAR TotalDeplaned = SUM(Cargo_Numbers[Ameriflight Deplaned]) + SUM('Cargo_Numbers'[American Deplaned]) + SUM('Cargo_Numbers'[Southwest Deplaned]) + SUM('Cargo_Numbers'[United Deplaned]) RETURN...

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...

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...

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.

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...

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. For...

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...

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...

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...

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...

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...

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...

(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 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...

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...