depending

Hi, I am currently trying to write a formula for a conditional format depending on two cell using EXCEL 2007. i.e i want to say if cell "Q5" contains anything (is not blank) and "R5" is =0 THEN turn "R5" Red. Any help would be greatly appreciated! Thanks

I am creating a new log book for our company and I want to have the 'calibration due date' modify automatically depending on two indicators (can't think of a better term). So I want A3 to change it's date depending on: A1's text (Gauge,Fork lift....) A2's date (calibration date) My hope is...

Is there a formula where: There is a drop down menu in column A, let's say the menu is Earrings, Necklace, and Rings. And depending on what the user selects, (Rings) I want column B to turn red. Once they enter in their ring size in column B (not a selection, they type it in) I want that cell...

I am trying to return all the numbers that appear in column L in column W, but only after a certain number of days (that changes depending on the amounts). This is for an investment program that releases locks and releases funds after a certain time period depending on the amount. The table in...

I am using a drop down on cell C3 on sheet 1 with reference to C 2 to C 50 in sheet 2. In D3 sheet 1, I would like to reference whatever is in D 2 to D 50 in sheet 2, depending on which item I choose in the drop down on C3. Example: Sheet 2: <tbody> </tbody> <tbody> C D E F 2...

Hi all, Appreciate any help to solve below:- Sheet1: [/URL][/IMG] B3 is a validation list to of company's. B4 is another validation list of products, depending on what company is selected in B3. Sheet2: [/URL][/IMG] On sheet1, I am trying to fill E4:I7 from data on sheet2, depending on...

Hi all thanks for reading this first of all! I need some help with something I thought was relatively simple but clearly not. What I need the spreadsheet to do is: if a cell in column c is a 1 then I need the cell next to it in column d be 67. If it's 2 then 69 so on and so forth up to 30. Is...

Hi All, So honestly not sure how to start something for like this... I'd like to create a Part Number Generator for hardware, we have number system but what I would like to do is depending what I choose, my options become limited to certain things, then once I have chosen everything, it...

I am trying to create a spreadsheet which will automatically sequence cars depending on how many there are. For example I want to enter: SUV- 4 GT - 7 and the spreadsheet would create a sequence like this: SUV, GT, GT, SUV, GT, GT, SUV, GT, SUV, GT, GT Where possible the sequence would be...

Hello, I have been searching the internet, but cannot find what i am looking to do. I have a spreadsheet with columns A to R. the relevant columns are A - Client name Q- Enhanced - will return ever 0 or 1 R - Calulates...

Good afternoon, I'm trying to create a nested formula in cell Y1 that will return the values of HIGH or LOW depending on a few criteria. 1) First off - I want the cell to return a blank value of nothing applies 2) Looking to have the value of HIGH or LOW returned depending on if the value in...

Hello! I've built a spreadsheet that needs some tweaking and I need help. Here is what I have: Cell 1-3 are just identifying data. Cell 4 Cell 5 Cell 6 Cell 7 $1250. $1300. $1200. ? The formula is needed for Cell 7. Currently...

Hi there, I'm trying to transfer data between 2x workbooks. I need to take the highlighted data from the below workbook (currently split between different 'agent' tabs) and consolidate that data into a second workbook where it is then split down further depending on what type of policy an agent...

Hi, I am not sure that this is even possible, but can you build a sheet that resembles a quote with a number of different blocks depending on cell values. I know that you can dynamically show a picture in a cell using the INDIRECT formula. Any thought would be much appreciated. Thanks in advance

Hello I am trying to write a formula for the following table example that would return result options in Column C depending on the data entered in columns A and B: IF A1=0 and B1>=133, then C1=ON if B1<133, then C1=NO; IF A1=1 and B1>=153, then C1=ON if B1<153, then C1=NO; If A1=2 and B1>=166...

Hello I am just wondering if it possible to populate the listbox depending on what has been chosen for the combobox and if so, how would you go about doing it? Thanks

Hello, would appreciate if someone could help me with this code. What i need is to automatically put a picture in userform after value in combobox is typed or selected. Combobox is in the same userform. The picture is with the same name as tha value. Both excel file and images files are in the...

Hi, Seems weird the tread title, sorry about that but i have no idea how to point the problem, because i don't know, please I need info about which formula to use to do the follow: On my sheet I'm Using 3 Ranges. Range 1, Search Cells, 4 cells located on (K1 to N1). (in fact there are not 4...

Hello all, This is my first post on here, familiar with some aspects of Excel but need some help with this please if anyone can help! I have a worksheet in excel that contains values from two other worksheets and compiles all the data into one large list. The list if you imagine contains Names...

Col B Col C Row 2 Count? Value Row 3 Y 10 Row 4 N 20 Row 5 Y 30 Row 6 N 40 Row 7 Y 50 Row 8 Row 9 What formula will total all of Col C range (Row 3 to 7) where Col B is a "Y"? (i.e. result should be 90). Tried a few things and can't get it to work. Can...