How to count cells by color in Excel Code - Custom functions to count by color in Excel. --------- Function CountCellsByColor(data_range As Range, cell_color As Range) As Long Dim indRefColor As Long Dim cellCurrent As Range Dim cntRes As Long Application.Volatile cntRes = 0 indRefColor = cell_color.Cells(1, 1).Interior.Color For Each cellCurrent In data_range If indRefColor = cellCurrent.Interior.Color Then cntRes = cntRes 1 End If Next cellCurrent CountCellsByColor = cntRes End Function Syntax

😫STOP wasting time to calculate payroll with Excel❗ Join us in our upcoming 𝐅𝐀𝐂𝐄𝐁𝐎𝐎𝐊 𝐋𝐈𝐕𝐄 𝐃𝐄𝐌𝐎 from 𝗔𝘂𝘁𝗼𝗖𝗼𝘂𝗻𝘁 𝗖𝗹𝗼𝘂𝗱 𝗣𝗮𝘆𝗿𝗼𝗹𝗹 and find out how #cloudpayrollsystem can 𝒎𝒂𝒌𝒆 𝒚𝒐𝒖𝒓 𝑷𝒂𝒚𝒓𝒐𝒍𝒍 & 𝑯𝑹 𝒑𝒓𝒐𝒄𝒆𝒔𝒔𝒊𝒏𝒈 𝒔𝒆𝒂𝒎𝒍𝒆𝒔𝒔𝒍𝒚 𝒂𝒕 𝒘𝒐𝒓𝒌. Don’t missed this opportunity ❗ 😫不要再浪费时间使用excel来计算薪资了❗快来留守 𝗔𝘂𝘁𝗼𝗖𝗼𝘂𝗻𝘁 𝗖𝗹𝗼𝘂𝗱 𝗣𝗮𝘆𝗿𝗼𝗹𝗹 在面子书线上直播的系统操作实践吧！我们将讲解 #cloudpayrollsystem 如何让你在处理人力资源和薪资工作上不再繁琐。一场您不容错过的 𝗙𝗕 𝗟𝗜𝗩𝗘 直播！ ===