Cond. Formatting

[mike]

I have a form, on which, I'm trying to format the dates so
they change colors when they approach todays date. Some of
the dates work fine while others don't. It's completely
random as to what works and what doesn't. The field for
the day is set as TEXT, not DATE, because I have some
areas that don't have dates and need to put text there. Is
that what is hosing up my formatting? Is there an EASY
workaround?

Thanks for your assistance,