How to make a cell blank if another cell is changed?

Albert 1 · May 10th, 2002, 09:58 AM

How can I make B1 blank if A1 is changed?
Thanks in advance for the answer.

Anne Troy · May 10th, 2002, 10:07 AM

You cannot make it BLANK in the true sense of the word, at least not only by using a formula. However, you can make it appear blank. For instance:

=IF(A1>=50,"",NONBLANKVALUE)

In other words, if A1 is equal to or greater than 50, and you want B1 to be blank in that case, put that formula into B1. The NONBLANKVALUE is what you want B1 to show if it is less than 50.

lenze · May 10th, 2002, 10:11 AM

Or place this cod in the WorkSheet Module

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address ="$A$1" Then [$B$1].ClearContents
End Sub

Albert 1 · May 10th, 2002, 10:56 AM

Thank you very much for the answers!

May 10th, 2002, 10:07 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	You cannot make it BLANK in the true sense of the word, at least not only by using a formula. However, you can make it appear blank. For instance: =IF(A1>=50,"",NONBLANKVALUE) In other words, if A1 is equal to or greater than 50, and you want B1 to be blank in that case, put that formula into B1. The NONBLANKVALUE is what you want B1 to show if it is less than 50. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 09:58 AM	#1
Albert 1 Board Regular Join Date: Feb 2002 Posts: 390	How can I make B1 blank if A1 is changed? Thanks in advance for the answer.

May 10th, 2002, 10:11 AM	#3
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Or place this cod in the WorkSheet Module Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address ="$A$1" Then [$B$1].ClearContents End Sub

May 10th, 2002, 10:56 AM	#4
Albert 1 Board Regular Join Date: Feb 2002 Posts: 390	Thank you very much for the answers!