Guys,
Hope you can help, this should be an easy one for a lot of you i think!
Say i have text in cell D11.
I want that to disappear if i type anything at all into cell C4...letters or numbers.
Can anyone help with this formula please?
Thanks people..
Welcome to the forum.
Which version of Excel are you using?
Not with a formula - maybe conditional formatting.
There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Use conditional formattung to turn the font colour in D11 to white, when C4 is non-blank using thsi as the CF rule:
=$C$4<>""
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.
Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/
(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...xcell.1254019/)
Glenn thanks so much for this help. It seems so easy now but i hadn't used conditional formatting before. Thanks again.Originally Posted by Glenn Kennedy
Sorry i didn't realise this was an issue posting on other sites! Thankyou all for taking the time to reply to me. Glenn above has helped me out thankfully. Now i am a user i will know for again. Thanks guys.
There isn't as long as you disclose it. Please read the forum rules page.
Which version of Excel are you using? Your forum profile needs correcting, please. 10 is Windows, not Excel. Thanks.
2016. Updated now.
Last edited by AliGW; 02-16-2024 at 08:55 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
Thanks.
You're welcome. Thanks for letting us know that you got an answer.
Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.
Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks