Conditional Format Problem

W

WLMPilot

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
 
B

Biff

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

Maybe this:

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

Biff
 
W

WLMPilot

Column C, which holds the value of the day of the month, are not full Excel
dates. They are simply the numeric value 10, 11, 12, etc. with a format of
GENERAL. I tried a format of NUMBER with zero decimals also to no avail.
 
B

Biff

Ok........

Are these values the result of a formula? If so, what's that formula look
like?

These values could possibly be TEXT numbers and not NUMERIC numbers?

Trailing and/or leading spaces in the cells? Is this data imported from
another application?

The problem has to be one of the above.

Biff
 
W

WLMPilot

Ok, I will check all of that out. Thanks for your help. If I am still
having problems, I will let you know what I have done and go from there.

Les
 
Top