Forum Widgets
Latest Discussions
Trying to create a dependent drop down with simple data
I need to create 2 drop downs. The first one I've created already and it works, but the second drop down is dependent on what the first says. Here is the data: I have used =INDIRECT("Category") within the Source field of a Data Validation list for the first drop down, which works. But what do I use for the dependent drop down?
Excel print to PDF issue
This is clearly a problem with my files, however, there is no clear indicator as to what the issue is. I have tried everything from resetting the print areas on each page to trying multiple pdf maker apps. I have a hunch it is that page one is in portrait and the later pages are in landscape but who knows. It has worked to print these files to a printer up until today and now I cannot print to PDF. the print preview shows me all pages but when i click print, it only stops at the first one and then continues after I save the first one. Basically, I print to PDF and the program (all programs) only print the first page (the one in portrait) and then ask where I want to save the rest of the pages (the landscape pages). I do not have the time to go through hundreds of documents and do this along with the follow up of then stitching the front page and the remaining pages together as it will cost me way way way too much time. Also my morals would be broken if I stooped that low and let technology win. its 2025 and if I cannot print to pdf with multiple orientations then wtf=IF Formula Woes
Hello All! I'm working on a spreadsheet with a cell (C2) containing a drop-down menu. I'm trying to create a formula in another cell (D2) dependent on the selected item in the drop-down menu. I was successful at doing this with the first menu item ("14 Day"), but when I tried to enter the formatting for the second menu item ("21 Day"), I got the dreaded #VALUE! error. I've attached some pics that hopefully explain what I was trying to achieve. The red section of the formula below gives me the error. =IF(C1="14 Day",SUM(B2*14))*C2, IF(C1="21 Day",SUM(B2*21))*C2 Any help or advice would be much appreciated! Thank you in advance!Conditional Formatting
To achieve this: I need these rules: First, green-fill the top 1 number per row. Second, outline-border the top 3 of all those top 1 numbers. Third, red-fill top 1 of those top 1 numbers. I can manage the first and third rules. But have no idea how to do the second rule, i.e., outline-border the top 3 of all those top 1 numbers. Please help, Excel 2016, thank you in advance!
IF Statement? Or conditional formatting... How?
1) Im trying to set excel up so that Column C has the date of a service that has been completed, Column D Im using the formula =EDATE(C2,3) to calculate the due date in 3 months. This is working okay however I have copied this formatting down the column but if in the next row Column C is empty it still throws a random date into Column D in that corresponding row. I don't want it to show anything in that cell until I complete the entry in Cell C in that corresponding row. 2) I have managed to set up conditional formatting so that Column D shows red if overdue up to 1 month, yellow if coming due in the next week or that week. In column E I have "Quote sent?" and I want it to change the date (background) in Column D to green if i say yes. I worked out how to make column cell (E) green if i say yes but not the cell to its left ie Column D cell. I want that formula to work the whole way down. Ie Im essentially wanting to check off if its done by turning it green so it overrides the red/yellow conditional formatting i have set for the date in Column D to green based off the response in column E
i need a bit of help on my sheet
so there is this i worksheet i've been working on for a couples of weeks now and i was wondering if someone could help me. so the pink/yellow cells are going to be hidden and the orange/blue are shown. my problem is when i select from the cell from A to the cells merged cells Q;R;S;T and i erase the content in them it also erases the cells between F and P which i don't want. so can i block or protect them from being erased ?
