Add cells based on a conditional format

[Robert_G]

I have two columns that are conditional formatted and highlight in color & text based on the formula above. How can I count all that is true in Column D and in f1, come with the value of 7 since there is 7 that are highlighted?

 

[Norie]

Probably a better way but try this.

=SUMPRODUCT(--(NOT(ISNUMBER(MATCH(D2:D28,A2:A3000,0)))))

 

[Robert_G]

It almost works. In column D, I need to check the whole column as there could be up to 3000 rows. So I changed the formula to this:

=SUMPRODUCT(--(NOT(ISNUMBER(MATCH(D2:D3000,A2:A3000,0)))))

Which in F1 the result is 2979. So it counted all the rows with text not highlighted. I some how need to count the highlighted only resulting in a value of 7.

 

[Norie]

Robert

That result probably has nothing to do with the highlighted cells, it's probably because of all the blanks in D2:D3000.