Hi!

Instead of counting the colored and non-colored cells, count based on your
due dates and the conditions used to impose the formatting.

If I remember correctly, the conditional formatting is based on:

If today equals the due date - red
If the due date is within 14 days of today - orange

So, count the due date cells based on those criteria.

Assume the due dates are in the range B1:B20

For: today equals the due date (red):

=COUNTIF(B1:B20,TODAY())

For: the due date is within 14 days of today (orange):

=SUMPRODUCT(--(B1:B20=TODAY()-14),--(B1:B20<=TODAY()-1))

For cells that don't meet either of the above criteria (no color): greater
than 14 days from the due date, and greater than today:

=SUMPRODUCT(--(ISNUMBER(B1:B20)),(B1:B20<TODAY()-14)+(B1:B20TODAY()))

Biff

"Kelly Lim" wrote in message
...
Hi Max, ....i download and open the url that u gave me....but y does the
whole column of

(1) Extracting ColorIndexes from E2:E5
(3) Count No of cells within the source range with the color

becomes #NAME?
#NAME?