如果判断已经有颜色的单元格是否为空值 ,请给出代码,谢谢!
Sub color_p()
For Each Rng In Range("A1:B100")
If Rng.Interior.ColorIndex <> -4142 Then
If Rng.Value = "" Then
MsgBox "发现带颜色的单元格存在空值" & "A" & Rng.Row
End If
End If
Next
End Sub
For Each Rng In Range("A1:B100")
If Rng.Interior.ColorIndex <> -4142 Then
If Rng.Value = "" Then
MsgBox "发现带颜色的单元格存在空值" & "A" & Rng.Row
End If
End If
Next
End Sub
温馨提示:答案为网友推荐,仅供参考