Disappearing Text in Excell

[Donal]

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..

 

[FormR]

Hi, welcome to the forum! Try this in cell D11, change the red part as required.

=IF(C4="","The text you want to appear in the cell","")

 

[Donal]

Hi, welcome to the forum! Try this in cell D11, change the red part as required.

=IF(C4="","The text you want to appear in the cell","")

Thanks for the reply!

So the text is already in D11. When i type something into C4 i want D11 text to disappear..

I think that's a little different to what you answered? Is it?

 

[Alex Blakenburg]

Do you mean conditional formatting ?
This turns the font white if there is something in C4

Book1
	A	B	C	D
1
2
3
4	This drives D11		Has data
5
6
7
8
9
10
11	Text in D11 change to white -->			Text in D11
12
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D11	Expression	=$C$4<>""	text	NO

 

[Alex Blakenburg]

Another conditional formatting option is instead of turning the font white you could set the number format to 3 semicolons ie ;;;

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Disappearing Text
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Peter_SSs]

Welcome to the MrExcel board!

The following vba is one way to achieve the result you have stated.
To implement ..
1. Right click the sheet name tab and choose "View Code".
2. Copy and Paste the code below into the main right hand pane that opens at step 1.
3. Close the Visual Basic window & test.
4. Your workbook will need to be saved as a macro-enabled workbook (*.xlsm).

Note that with this method, if the text is subsequently removed from C4 the other text will not return to D11. Whether you want that or not was not stated in your question.

Private Sub Worksheet_Change(ByVal Target As Range)
  If Not Intersect(Target, Range("C4")) Is Nothing Then
    If Len(Range("C4").Value) > 0 Then Range("D11").ClearContents
  End If
End Sub

 

[Donal]

Got it sorted now. Thanks guys for all the replies. Really appreciate your help.