Wouldn't it be great if there was a function that could count colored cells in Excel? . How to Format Partial Text Strings using VBA. using the same function by checking cells where the background color is set by Conditional Formatting. All I want to do is count how many cells of each color there are and have it show in a If the cells are colored using conditional formatting then you should be able to write count Tell us what version of Excel you're using Count cells by color in a spreadsheet (cells coloured. How to count by color and sum cells colored using conditional.