Hi,

I'm trying to count the font color of cells that have been conditionally formatted,

looking at the attached file, if you type the number 2 in cell s7 the font color in d2
and other cells change to white, I need to count those changes in the font color count column.

the font changes to white based on the numbers in the range s7:w20

If you could help me write this, it would be appreciated,

Thank you,

Truckdriver