![]() ![]() ![]() Basically, if you can make sure that whenever the cell is "empty" it's not actually empty but contains a zero-width space, you can get a conditional format to show your text. There's a work around that might help some people out. Note that the macro only kicks into action if the cell being changed is cell B4. Private Sub Worksheet_Change(ByVal Target As Range) OPENOFFICE CONDITIONAL FORMATTING BLANK CELL CODEThis would go into the code module for the worksheet being used: If you prefer to go a macro route, you'll want to create one that is triggered whenever there is a change in the worksheet. You could even, if desired, make the text in cell A4 a light gray, so it appears subdued when displayed. When someone types something in cell B4, this blocks what is in cell A4 from being displayed. You could make column A very narrow-say, about a single character wide-and then in cell A4 press the Space Bar a few times and type "Customer Name." As long as there is nothing in cell B4, what you typed in cell A4 is displayed, but it looks like it is in cell B4. Let's say, for example, that (again) your user input is expected in cell B4. There's also an approach you can use that takes advantage of the way that Excel deals with "cell overrun" when the cells contain text. If you want the wording to disappear when the customer name is entered, you could, instead, use a formula in cell A4: For instance, if the user input is expected in cell B4, you might put the wording "Customer Name:" (with the colon) in cell A4. The traditional way to get around it is to separate your prompts from your input cells. The short answer is no, this cannot be done. Sheryl wonders if there is a way to do this sort of "conditional formatting" that shows text. For instance, if the cell is empty, she might want to have it show "Customer Name," which would serve as a prompt to the user. Instead of a different color for the empty cell, she would like the empty cell to show some text. Sheryl can use Conditional Formatting to make a cell appear a certain color if the cell is empty. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |