EXCEL里怎样设置A列B列单元格为空时C列单元格显示为空，否则显示输入的数字？

Question

EXCEL里C1单元格是下拉列表单元格（下拉可选A、B、C、D等）当A1、B1单元格为空时怎样让C1单元格显示为空，否则显示可选的值，

Answer 1

在你要求实现的表里面复制下面代码！！！
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Selection.Row = 1 And Selection.Column = 3 Then
If Cells(1, 1) <> "" And Cells(1, 2) <> "" Then
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="a,b,c,d"

End With
Else
If Cells(1, 1) = "" Or Cells(1, 2) = "" Then
With Selection.Validation
.Delete
.Add Type:=xlValidateInputOnly
End With
End If
End If
End If
End Sub

修改一下

Answer 2

那你所要输入的数值必须不能在c列里，另取一列假设为d列，否则公式无效！你输入的公式为

1.要求同时空格满足条件的话
c1=if（a1=b1="","",d1)
2.其中一个满足条件的话
c1=if(or(a1,b1)="","",d1)