Automatically add text to cell if blank - MrExcel
Nov 20, 2024 · Hello peeps, I would like to automatically add the text "Target met" to a cell if it is blank (C1) and if a previous cell contains data (A1). I have tried several ways, but nothing is working (I am …
Formula to add text after a sum [SOLVED] - Excel Help Forum
Jun 6, 2006 · Formula to add text after a sum I have a time calculated cell for example =Sum (G2:G364) my result is 210 minutes, then I have another cell that divides it by 60 with a result of 3.5 I would like …
How do I fill a cell with text automatically when I click on the cell ...
Jun 15, 2021 · Hi. Is it possible to insert the letter "x" into a cell automatically whenever any cell in a range is clicked on with the mouse? If so, can someone be kind enough to show me how, please? …
Conditional Formatting Rule to insert text into a ... - Excel Help Forum
Jan 11, 2016 · Re: Conditional Formatting Rule to insert text into a blank cell if another cell contains You can't do what you want with conditional formatting - that just changes some of the formatting in a cell …
Suddenly can't insert text box, Why? [SOLVED] - Excel Help Forum
Mar 19, 2024 · Suddenly can't insert text box, Why? Worked on a spreadsheet and could insert text boxes and now I can't insert text boxes or graphics, and the spreadsheet is not protected.
Background text in Excel to be overwritten
Feb 20, 2009 · I am trying to create a section for people to enter an address, and in itself this is quite straightforward, but I want to be able to enter faint text in the cells as an information instruction that …
placeholder text - Excel Help Forum
Jun 23, 2022 · Hello. I'm using Excel 2016. I am trying to get standard placeholder text (for instructions to users). I understand that this cannot be done with conditional formatting or data validation. I have …
Insert text in cell based on conditional format? - MrExcel
Aug 11, 2017 · I'm new to Excel and use Mac Excel 2011. I understand the basics of conditional formatting but I can't quite figure out how to enter text in one cell based on whether another cell is …
[SOLVED] Add text to a cell that already contains text based on if ...
Jan 23, 2021 · I need a macro that will add the text ",Convenient" to a cell that already contains other text in column B if a cell in column A contains the word "mobile". The word "mobile" could be upper …
VBA to add text to cell, based on the value of a cell in ... - MrExcel
Oct 11, 2019 · I need help with a VBA code that can add "COVERING" text to an empty cell in Sheet 2, based on the value of Sheet 3. It will be for specific columns, for example Sheet 1, Column G based …