Complex conditional formatting involving varying ranges

[Thomasvd]

Hi guys,
We have a document based on the lottery, "LOTTO"
All those names have 10 numbers, from Colum D to M.
Now i use conditional formatting to color numbers that match.

To explain how everything works:
Each 3 days there will be a lotery with 6 numbers.
U can find the current numbers in colum D196 till I196 (thats one lotery)
The other lotery's are lower from D 197 till I197 and so on.

Now what do we need to have?
If i enter the 6 numbers from D202 Till I202, they have to be colored in red "background" with the matching cells in range D2:M154
Now this works with conditional formatting, but as final work, i need to count how many numbers the participants need to have them all. "Colum P"
I need to count how many numbers they still need to complete their winning.
Example, MAGDA P in B2 needs only 1 number, number 34 in I34.
So this needs to be calculated in Colum P .... Counting range D2 till M2 minus 10 numbers....
That should be no problem, the only problem now is, that conditional formatting is not allowing u to connect with VBA or standard formules....
If i use CF it will count the range as not coloured.... because CF is laying on top of that
Anyone has a proposal for this?
Maybe a new way to light the cell up in VBA?


Project example:
ftp://esekk.dyndns.org:1337/Lotto.xls

Thanks in advance....