Conditional Format Problem
 

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

Conditional Format Problem
 

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

Conditional Format Problem
 

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.

"Biff" wrote:

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

Conditional Format Problem
 

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

"WLMPilot" wrote in message
...
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.

"Biff" wrote:

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

Conditional Format Problem
 

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

"Biff" wrote:

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

"WLMPilot" wrote in message
...
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.

"Biff" wrote:

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