mmsamaddar
New Member
- Joined
- May 26, 2015
- Messages
- 14
Hi, I have in a problem, please be with me.
If cell A1 is blank, then Cell B1 looks invisible
If cell A1 is not blank, then Cell B1 looks also invisible
If cell A1 has unique value, then Cell B1 looks visible only
Note: A1 can be deleted or belongs a unique number that I created with Data Validation
For Conditional, I used the formula
1. =$A$1=""
2. =$A$1="unique number"
Here is the problem: If I try to input a number in cell A1(excluded unique number), then the Cell B1 shows the secret figure.
Actually, I want to use a unique number or PIN in the cell A1, the Cell B1 will be visible then, otherwise not visible. Though I used =IF(A1="","",Cell_B1_Formula)
Thanks in advance & waiting for the response
If cell A1 is blank, then Cell B1 looks invisible
If cell A1 is not blank, then Cell B1 looks also invisible
If cell A1 has unique value, then Cell B1 looks visible only
Note: A1 can be deleted or belongs a unique number that I created with Data Validation
For Conditional, I used the formula
1. =$A$1=""
2. =$A$1="unique number"
Here is the problem: If I try to input a number in cell A1(excluded unique number), then the Cell B1 shows the secret figure.
Actually, I want to use a unique number or PIN in the cell A1, the Cell B1 will be visible then, otherwise not visible. Though I used =IF(A1="","",Cell_B1_Formula)
Thanks in advance & waiting for the response