13K views · 440 reactions | Need to identify cells fast? Conditional formatting to the rescue! | Microsoft Excel | Facebook

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

Have you had a chance to check out Microsoft’s new color theme? Here is a link to our full tutorial: https://www.excelcampus.com/library/new-microsoft-office-theme-2023-how-to-migrate-or-revert-back/ #microsofttips #microsoftexcel #officetips #excelcampus #officeproductivity | Excel Campus