å
¶å®æ¡ä»¶æ ¼å¼å°±å¯ä»¥è§£å³ï¼æ¯å¦åå
æ ¼B1ï¼æ¡ä»¶æ ¼å¼ï¼å
¬å¼ï¼=MOD(B1,2)=1ï¼æ ¼å¼å¡«å
红è²ï¼
å¦æä½ éè¦ç¨VBAï¼ä»£ç å¦ä¸ï¼
Sub test()
Dim cell As Range
For Each cell In Range("A1:B4")
If cell <> "" Then
If cell Mod 2 = 1 Then
cell.Interior.Color = vbRed
Else
cell.Interior.Color = vbGreen
End If
End If
Next cell
End Sub
请èªå·±ä¿®æ¹ç²ä½é¨å
温馨提示:答案为网友推荐,仅供参考