- ©«¤l
- 396
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 425
- ÂI¦W
- 1
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2013-7-2
- ³Ì«áµn¿ý
- 2024-8-23
|
¦^´_ 1# vesperlee
¬°¤°»òn±Æ¥¸°j°é~~- Sub TEST_1()
- For Each rg In [b2:g14]
- If rg >= 1000 Then
- rg.Interior.ColorIndex = 8
- ElseIf rg >= 600 Then
- rg.Interior.ColorIndex = 7
- ElseIf rg >= 300 Then
- rg.Interior.ColorIndex = 6
- ElseIf rg >= 100 Then
- rg.Interior.ColorIndex = 5
- ElseIf rg > 0 Then
- rg.Interior.ColorIndex = 4
- ElseIf rg <= -1000 Then
- rg.Interior.ColorIndex = 24
- ElseIf rg <= -600 Then
- rg.Interior.ColorIndex = 23
- ElseIf rg <= -300 Then
- rg.Interior.ColorIndex = 22
- ElseIf rg <= -100 Then
- rg.Interior.ColorIndex = 21
- ElseIf rg < 0 Then
- rg.Interior.ColorIndex = 20
- Else: rg.Interior.ColorIndex = 0
- End If
- Next
- End Sub
½Æ»s¥N½X |
|