•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Conditional formating an empty cell based off of another cell
Our take
Are you struggling to manage conditional formatting in Excel, especially when dealing with empty cells? If you're using distinct equations for different cases, it can be frustrating when you want to denote unused variables with "N/A" but Excel only applies formatting to populated cells. In this guide, we'll explore how to effectively implement conditional formatting so that your worksheet dynamically reflects which areas are in use and which are not. Stay tuned to unlock a solution that enhances clarity and organization in your data management.
Hello !
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.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- Cell merging / formatting formulasThis might be an odd one. I'm not that skilled with excel as my use of in within my job is pretty limited. However, I tend to use this template my predecessor made to summarize data from our program. Works well, just a simple ='SHEET 1'!A1 for all cells. The first two images give an example. After the data is ported, I have to get rid of the zeros between the data and write system names. When it comes to pasting it on letters, the names are bolded, upped a font size, and two of the cells are merged (3rd image) This gets a bit tedious as the lists can get pretty long so I've been trying to figure out how to streamline it on my own. My idea has so far has been to have a separate cell detect when I'm finished adding my data and then format the aforementioned cells (4th image). For the life of me, just can't figure out how to write a formula to do it. What I would need is for the formula to detect a 1 (could be anything) in cell G10. It would then check for any blank cells in columns A and B. Once found, it would merge & center, bold the text, increase the font size, and align right. Is this only possible with a macro? I've been unable to find any formulas that could accomplish this. https://preview.redd.it/853mpr4jspog1.png?width=788&format=png&auto=webp&s=943a34a57f1d7c7f88256dd89b81b9c6fc301e34 https://preview.redd.it/e3w6ms4jspog1.png?width=453&format=png&auto=webp&s=9b189fa77d6638b627f8676dad60bc148753617c https://preview.redd.it/msh6ys4jspog1.png?width=411&format=png&auto=webp&s=d5f5025b315f24fd5f3a64c6e07e019abd3a77ab https://preview.redd.it/7j66tt4jspog1.png?width=936&format=png&auto=webp&s=1faa4df12ee74892f5fa9dc27ac95621280cf3c5 submitted by /u/Extension_Train9093 [link] [comments]
- Conditional formatting for highlighting cellsI have two very lengthy columns, let’s call them column A and column B. I need to highlight all of the cells in column B whose content does not appear in column A, but there are 80+ cells I’d have to check and it’d take me a really long time. I’m in no way an expert on excel but I do know I’d have to use conditional formatting, I just don’t know how to build the formula for this :( submitted by /u/Nandolvs [link] [comments]