conditional

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

I'm trying to write some VBA code that will tell me if a row containing exact data exists. The table (Table1) is formatted as a table with headers, and has 20 columns; the first three columns are what I am concerned with right now. - Some projects will have multiple associated sites - Some...

In a data set, I'm trying to identify a way to lookup the first instance of a transaction type and its corresponding date and the first instance of a second transaction type (and corresponding date) that occurs after the first transaction type. In the enclosed example (click on image), in the...

Hi There! I am trying to write a formula that allows me to place a dash before the last character in a cell text if it is an A,B,C etc. For example, if I have a sku that reads JH004A and I would like a formula that will populate another cell with JH004-A. IF it doesn't contain A,B,C etc. I want...

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

I feel like this is a basic question but can't figure out how to automate it with a macro. Example of what I'm trying to do: Column A has Cities and Column B has the time zone. I need to replace the time zone based on the city to the state it belongs in. I know how to set it up the slow way of...

I tried creating a table to aid a manufacturing process. Where technicians perform some test and record the results. One of the column (unit #) auto populates based on other column entries of the table. The unit # column helps keep track since a technician is supposed to test 14 units in a...

Hello everyone~ I have a problem with a task that I'm not sure how to do it. I have an excel file where I make quotations and it brings a total quotation at the end. According to that quotation result I have an ActiveX combo box that should bring a specific range of values, for example...

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.

Hi, I'm using conditional formatting and for all of the ones I have used (equal to and contains) when i removed the text it leaves behind a half border like so: It stays there unless I go into the formula line and press enter. I would like it if it doesn't do that. Does anyone have any tips...

I am working on a VBA code to do a couple things. The first is to add a new row and add the information I put into a seperate list. I want it to do this unless the Case Number and the Charge is the same. If those two things are the same then I want to fill in the rest of that row with that...

Hi, I'm very new to Excel and need some help (with a maybe very basic function). I need to create a system that choose between two parameters to round up or down the number depending on a condition. This is for scoring students with a decimal system, so I need to round the final score. What I...

Hello, Could someone please help me with the IF statement in column Q? The formula should be If Column J is "Y" then remove substring "HM" from column P. The formula I'm trying is also deleting everything after the substring and if the substring doesn't exist then it's giving me #VALUE...

SKU STORE A A DATE STORE B B DATE 71011 1.87 2/21/21 1.69 10/7/21 71115 1.07 3/22/22 NA X FPF3 NA X 1.78 3/22/22 650876 6.34 9/21/21 6.08 10/8/21 503EZ NA X 9.00 3/22/22 72014 3.60 2/22/22 NA X 98823 NA X 5.05 2/21/22 PROBLEM: look up SKU and...

I'm a n00b and I've been searching the forums and the closest thing I can find to my problem was addressed here: Simple Macro to cut and paste based on cell value I'm trying to have any cells in column M that are greater than 0 be cut and paste into a column 3 columns to the right of the...

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

Hello, I am using Power Query to pull multiple data sets into a single workbook. I have a table within that workbook that contains a dropdown. What is selected in that dropdown determines how the data pulled in by Power Query gets filtered. See attached for further explanation. It works...

Hi, I am hoping someone could assist me please. I am helping someone with a spreadsheet and they are wanting to flag dates at various stages. Essentially they are looking for two queries; - When 10 business days have passed column P (Closing date), column W (Selection Report finalised) will...

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

Hi Gurus, I have been lurking for a few days trying to find a solution but nothing quite fits, so I am hopeful some bright spark will share their knowledge with me. I have a spreadsheet that is gathering data every day (31 sheets - one for each day of the month). At the end of the day I (or a...