MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Count of Fill Color


Posted by Alan Robertson on September 14, 2001 11:00 AM

I am looking for a formula what will do a count function to determine the number of cells in a column with a specific fill color. Anyone know of one?


Posted by Aladin Akyurek on September 14, 2001 11:14 AM

You can use in a counting formula the condition(s) by which you determine that a cell gets a certain color. Just an example: each cell with a value higher than 50 are colored red in the range A1:A50.

=COUNTIF(A1:A50,">50")

will give the number red colored cells.

Aladin