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