Is C478 a full Excel DATE or is it just a number like 10?

Maybe this:

=AND(C478<"",DAY(C478)<=DAY(TODAY()))

Biff

"WLMPilot" wrote in message
...
I am pretty good at conditional formatting, but I am stumped on this one
and
I know it is something simple.

I have a budget in Excel. Column C contains the date due, ie 10, 15, 20,
that the payment is due. Since I have 12 budgets (ea month) on one sheet,
I
already have the text for the current month change to blue. What I am
trying
to have happen now and can't is to have each line change to a yellow
background if the date due is less than or equal to today's date. Here
are
the two formulas I tried but did not work:

=AND(C478<"", C478 <= DAY(TODAY()))
=IF(C478 <= DAY(TODAY()))

I made sure that "DAY(TODAY())" was a valid format by inserting this
formula
in a blank cell with an "=" before it, and it worked.

Any ideas??

Thanks,
Les