Private Sub Worksheet_Change(ByVal Target As Range)
If [t25] - [b2] <= 1 / 24 / 24 * 30 Then
Application.Speech.Speak "支付宝到账500万元"
Range("s25").Interior.ColorIndex = 6 '黄颜色
Else
Range("s25").Interior.ColorIndex = xlNone
End If
End Sub 测试2.rar(35.81 KB, 下载次数: 22)