•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
If = "Blank" then fill Cell "Blank"
Our take
Struggling with Excel can feel overwhelming, especially when you have a task to complete for your boss. If you need to automate how Column N responds based on whether Column H indicates "Independent" or "Dependent," you're in the right place. By leveraging a simple formula, you can streamline your workflow and eliminate guesswork. Keep reading to discover how to set this up efficiently, ensuring your spreadsheet reflects the correct information with ease. Let’s turn that frustration into a seamless solution!
I particularly suck at excel and am trying to get a head start on a task my boss gave me. I am attempting to fill out a sheet for work to fill out the following cells If Column H= Independent then Column N should auto-fill to N/A. If Column H= Dependent then Column N should be left blank. Is there a way to do that?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Replacing blank cells with free version of ExcelHello everyone! I just started to learn to use Excel and I'm already stucked with a problem😅 I have to fill in blank cells with the text "N/A" but in the free version of Excel is a bit complicated I searched on the internet but the main solution is to use the "GO TO SPECIAL" option, which I didn't find on the free version. For this, I'd like to ask to the community if you may have any solutions or, if you encountered the same problem, how did you solve that? Thank you! 😊 submitted by /u/Icy-Permission6675 [link] [comments]
- Conditional formating an empty cell based off of another cellHello ! I am currently working on a worksheet that has 2 tables for two distinct equations that are used in 2 distinct cases. Case 1 uses Equation 1 that has 9 variables Case 2 uses Equation 2 that has 7 variables In the E column I inserted Text that dictates if I use Equation 1 or Equation 2. The variables for Equation 1 are written on F:N, and the variables for Equation 2 are written on O:U. Now, I want to write a conditional formating for cells that adds "N/A" to the cells that aren't currently in use by the Case in question. So, if for the row 4 I have in the E collumn "Case 1", I want cells F4:N4 to remain blank and to be able to write in manually the data, while cells O4:U4 to have the "N/A" notation since they're not in use. The issue is that excel won't add the "N/A" notation unless something is already written in the cells. I want to make it write "N/A" even when the cell is empty. I use excem 2010. submitted by /u/suffering_addict [link] [comments]
- How to make conditional formatting exclude blank cellsMaking a working hours chart but I'm not very well versed in many Excel functions so I've been consulting google results for most, but I don't understand why conditional formatting is marking blank cells green for value >0. The detailed issue is as follows: I have columns for for date (C), start time (D), end time (E), and the following (using row 5 for example): Total time F5 =IF(D5;E5-D5;"") Number format: Time Overtime: G5 =IF(OR(F40="";TIME(8;;)="");"";(F40-TIME(8;;))*24) Number format: General I have set up conditional formatting in column G to color everything that is below 0 red, everything above 0 green, but all the blank cells with above formula applied are colored green too. Cells that equal 0 are left without color, as I intended. My hope is that blank cells also remain white until they recieve a value. Is there a way to achieve that? I appreciate all the help! submitted by /u/ace_098 [link] [comments]
- How to stop data in new cells from inheriting formatting from previous rows?I have a sheet where certain rows / columns have fill colors applied to make things easier to read. For example: Rows 1-12 (Jan - Dec 2025 ) have a fill color. Rows 13-24 (Jan - Dec 2026) do not have any fill color with the exception of column B, which has the manager's name. I can highlight the cells in rows 13-24 and set them to have no fill. But when I type a value in any of those cells and tab or enter, the cell inherits the color fill from the section above, even if the row directly above it has no fill. There is no conditional formatting in use on the cells/rows in question. I typed 15 in cell F9 and clicked enter, but I do not want this formatting to auto apply. submitted by /u/StandardWriting3069 [link] [comments]