file:///C:\Users\lq\AppData\Roaming\Tencent\Users\646058203\QQ\WinTemp\RichOle\]%MQB4K99U{M9MGT(}]T0RS.pngfile:///C:\Users\lq\AppData\Roaming\Tencent\Users\646058203\QQ\WinTemp\RichOle\]%MQB4K99U{M9MGT(}]T0RS.pngSub 判断1() '单条件判断
If Range("a1").Value > 0 Then
Range("b1") = "正数"
Else
Range("b1") = "负数或0"
End If
End Sub
Sub 判断2() '多条件判断
If Range("a1").Value > 0 Then
Range("b1") = "正数"
ElseIf Range("a1") = 0 Then
Range("b1") = "等于0"
ElseIf Range("B1") <= 0 Then
Range("b1") = "负数"
End If
End sub
If Range("a1").Value > 0 Then
Range("b1").颜色属性 = "红色" 假如这里变了属性,下面的该怎么该,是默认颜色属性还是value
ElseIf Range("a1") = 0 Then
Range("b1") = "等于0"
ElseIf Range("B1") <= 0 Then
Range("b1") = "负数"
End If