Steve:

Doable = Yes. Practial = No.

Needs to have DC run automatically every night to update the color codes or do it manually.

The problem is that the year to date stats are not rolling and for what your client is looking for a rolling year to date sales would be more appropriate.

I don't believe there is any audit trail to flag when the color changed.