On Sat, 29 Nov 2008 08:56:01 -0800, Mike Busch
wrote:

In 2003 when I try to use a conditional format on a date field, I select the
field and set if for less than Now (). This will change the date to red when
a bill is past due. I am doing something wrong, because no matter what date
is there, all the date cells in this field turn red. What am I doing wrong.
Thanks in advance

Take a look at the conditional format formula.

If you just type <Now() into the formula box, Excel may have turned it into a
string: ="<Now()"

You may just need to delete the quote marks, if that is the case.
--ron