Need formula to calculate the count on colour Issue is the cells are in Conditional Format

Dear Team,

I have a excel with Name and status Whether A or B like that.. i want the count of the cells in colour basic. The colour are defined from the values using conditional format. pls help its my daily work with take more time..thanks in advance. i have attached the excel also

your conditional formatting is as follows

Yellow between and equal to 98.5 and 99.9
Red > 98.5
Green >=99.9

so you have = 99.9 twice - for green and yellow
Plus quite a few other rules for the colours

also cell d2 is 70.91 - but its yellow

to count , you can use countifs()

for one of your yellow rules as described above then
=COUNTIFS(D2:D7,">=98.5",D2:D7,"<=99.9")
OR if there is only one criteria for example
=COUNTIF(D2:D7,">70")
=COUNTIF(D2:D7,"<=80")

if you could post the rules you want to apply for your conditional format , then the countif/s () can be setup to correspond

You can also use the status column to decide the rules as well , with a nested IF

you will need VBA to do that , not my area of expertise, sorry