counting cells based on cell color

[lezawang]

Hi
I have a column which has some cells in red color. I want to have another column beside it and if the cell color that is adjacent is in red then i type number 1 and then keep counting other cells which has red color. Basically I want to say can i count number of cell based on color? if yes, how? Thank you so much.

[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]100 [cell color red][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]200[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]300[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44 [cell color red][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]33 [cell color red][/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Native Excel formulas only work on values, not on formatting.
So you would need to create your own Excel function in VBA to do this.
If you do a Google Search on "Excel VBA Count by Color Function", you will find many links with ready made code you can copy to do this.
Here is one: https://support.microsoft.com/en-us...f-cells-with-specific-cell-color-by-using-vba