Counting of Conditional Formatting data

[pglibra]

Hello,
I am trying to count the number of instances a certain value (Company) is listed in a conditional formatted cell, where the conditions are as follows: if cell value for # of Days <4, highlight cell green; if cell value is between 4 and 9, highlight cell yellow; and if cell value >9, highlight cell red.

Company # of Days
9 110
9 110
9 0
13 6
13 2

So for this example, company 9 had 2 instances that were highlighted in red and 1 instance that was highlighted in green. Company 13 had 1 instance in yellow and 1 instance in green.
The # of Days column alre


Hope I explained it well.
Thanks

 

[duggie33]

I do not think you want to count the Conditional Formatting per se. I think you want to write a countif formula to check for the same conditions used in your conditional formatting. For instance a Countif for the “company equals 9 and number of days is >9”. There are a lot of references on the internet for writing Countif formulas.

Hope that helps,

Doug