Formula to calculate total number of colored cells

[barim]

I need a formula that would calculate a total number of cells that are colored in each column. For example, in the cell C100 should be formula that would give me a count of cells that has background color green. There are no multiple colors throughout the worksheet, it is only one color - green. Total numbers should be placed from cell C100 until N100 and my data is within range of C2:N99. Is there any way to do this using formula instead of VBA? If there is no any formula solution, then I will have to use VBA solution.

Thank you in advance.

 

[dreid1011]

Are you using conditional formatting to color the cells? Because there is no formula that can detect a cell color. If it's conditional formatting formula applying the color, then we can work with that to get a count.

 

[barim]

dreid1011, thank you for your reply. I wish we have countif formula that can calculate this. To answer your question, I've got these highlighted cells through running a macro. I actually found solution by inserting one of Ozgrid's custom functions which works perfectly for this case and it is relatively fast. I wish Microsoft builds us formula instead of having involved these custom built functions.
Thanks again for your reply.

 

[dreid1011]

You're welcome, glad you found a solution.