I have a bit of a question for the group... I was wondering if there might be a way to set things up so that if, say, I enter a specific number or a date into cell A1, then cell B1 becomes essentially locked down so nothing can be typed there? Basically, I'm looking to disable any input in cell B1 whenever cell A1 contains a number, and perhaps even flip the logic so it works the other way around too, if that's even possible.
Walter Jackson48 said:I'm on the same page here. I had gathered that A1 would only be populated with values that aren't zero. I suppose we just have to hope the user picks the specific formula that actually fits their needs, and then—if they're feeling generous—let us know which one they went with, so we can finally figure out if our work was actually helpful.
I suppose both approaches would technically work. Since I'm not even inputting a zero in the first place.
I was hoping I might be able to get a little bit of guidance regarding a small issue I've run into...
For instance, I’m trying to set it up so that cell B1 pulls whatever value is sitting in cell A1, but if A1 happens to be empty, I would much prefer for B1 to stay completely blank. The thing is, whenever I try using the standard formula like =A1, it just populates B1 with a zero instead of leaving it empty, and that's actually causing me quite a few headaches with my data.
I was wondering if anyone might happen to know if there's a specific formula out there that allows you to sum up all the cells in a column based on their fill color—for instance, if they're highlighted in red. To be clear, I mean the cell background color itself, rather than just the font color.
I was wondering if anyone might be able to help me out with an Excel formula... Suppose we're looking at three specific cells. The first cell will always contain a number, the second one could be either a number or some text, and then the third one is just another number. So, I suppose what I'm trying to achieve is this... I want to add the first cell to the second one, but if there happens to be text sitting in that second cell instead, then the formula should add the first cell to the third one instead. It might make things a bit simpler, I guess, if the text used in that second cell is always the exact same thing.
If anyone happens to know how to pull this off, I think it would be an immense help.