â å©ç¨æ¥æ¾åè½ï¼Ctrl+Fï¼æ ¹æ®ä¸å¾æä½
å¨å·¦ä¸è§å°±çå°æ¾å°çåå æ ¼æ°ç®äºã
â¡ä½¿ç¨VBAï¼2010çæ¹æ³ï¼å¼åå·¥å ·-visual basicï¼å·¦ä¾§ç¬¬ä¸ä¸ªï¼æ¤æ¥éª¤å¯ä»¥å¨å·¥ä½è¡¨æ ç¾ä¸å³é®ï¼æ¥ç代ç æ¥æå¼,å¨æå¼ççªå£ä¸ï¼éä¸æå ¥-模å-åå»æå ¥ç模åï¼å°ä¸è¾¹ä»£ç å¤å¶å°çªå£ä¸ã使ç¨æ¹æ³æ¯ï¼å¨åå æ ¼ä¸è¾å ¥å ¬å¼=countcolziti(åæ°1ï¼åæ°2)ï¼åæ°1为ç»è®¡ä¸ªæ°çåå æ ¼èå´ï¼åæ°2为ç»è®¡åä½é¢è²çä»»æä¸ä¸ªåå æ ¼ï¼å¦=countcolziti(a1:c5,a1)ã
Function Countcolziti(countrange As Range, col As Range) As Integer
Dim icell As Range
Application.Volatile
For Each icell In countrange
If icell.Font.ColorIndex = col.Font.ColorIndex Then
Countcolziti = Countcolziti + 1
End If
Next icell
End Function
â¢å©ç¨å®è¡¨å½æ°get.cellè·ååå æ ¼åä½é¢è²ä»£ç ï¼æ¹æ³ï¼å ¬å¼-å®ä¹å称ï¼è§ä¸å¾ï¼
注æå ¬å¼ä¸çA1ä¸è¦åæ$A$1ï¼ZTSæ¯æèªå·±å®ä¹çå称ï¼ä½ ä¹é便ç¼ï¼æ±åä¹è¡ï¼ç¶åå¨å ¶ä»åå æ ¼è¾å ¥=ZTSï¼å车ï¼æå¨å ¬å¼ï¼å¾å°ç»è®¡èå´å å个åä½çé¢è²ä»£ç ï¼ä¸å¾ä¸æ两ç§ï¼çº¢è²åéè²ï¼ï¼ç¶åå¨å¦å¤ä¸ä¸ªåå æ ¼ç¨å ¬å¼ï¼å设ç»è®¡çº¢è²=countif(e1:g7,3)