ç¨åºä»£ç ï¼
æµè¯ææï¼
注æï¼
ç±äºçº¢æ许å¤ç§çº¢ï¼é¢è²å¤ªå¤äºï¼ä»£ç æ¯å¯¹éé»çè¿è¡ç»è®¡ï¼ç»¿è²ãèè²é½ä¼å å«ï¼ä»£ç å¦ä¸ï¼
Option Explicit
Sub å®1()
Dim i&, j&, n&
For i = 1 To 5
n = 0
For j = 1 To 9
If Cells(i, j).Font.Color <> 0 Then n = n + 1
Next j
Cells(i, 10) = n
Next i
End Sub
å¦æéè¦åºåç¹å®é¢è²è¿è¡ç»è®¡ï¼ä»£ç ä¸ä¸é¢çè¡å¯è½éè¦ä¿®æ¹ï¼
If Cells(i, j).Font.Color <> 0 Then n = n + 1
ä¾å¦ä¿®æ¹ä½åªç»è®¡é¢è²ä½255ç纯红è²ï¼
If Cells(i, j).Font.Color = 255 Then n = n + 1