Counting conditionally formatted font color not pre-formatted font color

I have a set of cells that have a number and the font is pre-formatted to black but will conditionally change
to white when the condition of a number matching another cell is met.

I'm trying to count the font color of cells that have a conditional format of white not the preformatted color of black.

I did make a file in excel if someone wants to sees it,

Thanks,

for some reason, the copy file wouldn't download properly, it was saying the file couldn't be found

the code worked perfectly but now I've expanded my sheet to include more salespeople and daily sales stats

I just need the ranges to be unlimited, I tried to expand the last ranges and it didn't go well.

Guess I can't attach a file,

send your email and i'll email the file, looks like I can only attach a file once

got it figured out, here's the file

Jete,

The code works, but I was wondering about tweaking it a bit,

I re-attached the file, is it possible to have o7 count the range of d7:m7 by font color that
was conditionally formatted?

If I change the font color to white manually, it counts it just fine, but when the color is set by
conditionally format, it doesn't count.

if you type the number 2 in d7, you'll notice that font color changes to white in other cells that contain the number 2 also, and I need those font color changes to be counted in the "Font color count" column
Thanks