Yakuzauex

 I am using this VBA code to count the number of interior color cells within a range Function countif_by_color (rl As Range, r2 As Range) As Long ApplicationVolatile Dim x As Long Dim cel As Range x = 0 For Each cel In rl If celInteriorcolor = r2Interiorcolor Then x = x 1 End If Next countif_by_color = x End FunctionUse COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion;Count Cells that contain specific text A simple COUNTIF function will do the magic To count the number of multiple cells that contain a given string we use the wildcard operator with the COUNTIF function Excel REPLACE vs SUBSTITUTE function The REPLACE and SUBSTITUTE functions are the most misunderstood functions To find and replace a Countifs Excel S Countif For Multiple Criteria Pryor Learning Solutions How to use countif in excel for color