count words with different background colors

[Leda Leong]

Dear all,

really need help, how to set a formula or VBA to count the below:
As I want to know how many as below in the column

SA under yellow background = 12
SA under red background = 1
SA√ under yellow background = 4
SA√ under red background = 1

[TABLE="width: 38"]
<colgroup><col width="50" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;"> <tbody>[TR]
[TD="class: xl255, width: 50, bgcolor: yellow"]SA[/TD]
[/TR]
[TR]
[TD="class: xl255, width: 50, bgcolor: yellow"]SA[/TD]
[/TR]
[TR]
[TD="class: xl255, width: 50, bgcolor: yellow"]SA[TABLE="width: 38"]
<colgroup><col width="50" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;"> <tbody>[TR]
[TD="class: xl256, width: 50, bgcolor: yellow"]SA√[/TD]
[/TR]
[TR]
[TD="class: xl256, width: 50, bgcolor: yellow"]SA√[/TD]
[/TR]
[TR]
[TD="class: xl256, width: 50, bgcolor: yellow"]SA√[/TD]
[/TR]
[TR]
[TD="class: xl256, width: 50, bgcolor: yellow"]SA√ [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="class: xl255, width: 50, bgcolor: yellow"]SA[/TD]
[/TR]
[TR]
[TD="class: xl255, width: 50, bgcolor: yellow"]SA[/TD]
[/TR]
[TR]
[TD="class: xl255, width: 50, bgcolor: yellow"]SA[/TD]
[/TR]
[TR]
[TD="class: xl254, width: 50, bgcolor: red"]SA√[/TD]
[/TR]
[TR]
[TD="class: xl256, bgcolor: red"] [/TD]
[/TR]
[TR]
[TD="class: xl257, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl255, width: 50, bgcolor: yellow"]SA[/TD]
[/TR]
[TR]
[TD="class: xl256, bgcolor: red"] [/TD]
[/TR]
[TR]
[TD="class: xl256, bgcolor: red"] [/TD]
[/TR]
[TR]
[TD="class: xl255, width: 50, bgcolor: yellow"]SA[/TD]
[/TR]
[TR]
[TD="class: xl257, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl256, bgcolor: red"] [/TD]
[/TR]
[TR]
[TD="class: xl257, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl257, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl257, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl255, width: 50, bgcolor: yellow"]SA[/TD]
[/TR]
[TR]
[TD="class: xl255, width: 50, bgcolor: yellow"]SA[/TD]
[/TR]
[TR]
[TD="class: xl255, width: 50, bgcolor: yellow"]SA[/TD]
[/TR]
[TR]
[TD="class: xl255, width: 50, bgcolor: yellow"]SA[/TD]
[/TR]
[TR]
[TD="class: xl254, width: 50, bgcolor: red"]SA[/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

Formulas cannot read the colours of cells (unless you have set them by Condtional Formatting), VBA would be your only option.
If you have set the colours by CF then just use the same conditions to determine the colour.