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.

100 [cell color red]	1
200
300
44 [cell color red]	2
100
33 [cell color red]	3

<tbody>
</tbody>

 

[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