Conditional formatting by day of the date in Excel 2003

[billz]

I use a worksheet for each month to track my bills.
I enter a due date of each bill in Month Day Year eg. 03/14/01.
I would like for my date that I would enter to change color if the Day is
less than the previous date entered.
eg March tab has card due on 03/14/01, and in April the date may be 04/10/01.
I would like April date to be Red, for example.

Can this be done?
Thanks for your responce.

 

[Barb Reinhardt]

Are you saying that if the day of the month is less, you want it to show in
RED?

I think I'd use a formula something like this

=Day(A1)< Day (A2)

Where A1 is last months cell and a2 is this months cell

 

[billz]

I tried:
=Day(AUG!$N$4)< Day (SEP!$N$4)
September day was earlier than August day, but I received an error that I
can not do it.
Error read; You may not use references to other worksheets or workbooks for
Conditional Formatting criteria.

Strange because I already use valuse from previous worksheets in this file.

 

[Barb Reinhardt]

OK, I see the problem now. You'll need to define a workbook level named
range to be able to do this. This named range needs to be defined for the
cell that is not on the active sheet. Come back if you need more help.

 

[billz]

SURE....

That’s a mouthful.

I figured out how to label a cell, then how to accept labels in formulas,
but.... it just drops you off there with no more info on what you do with
the labeled formatted cell.
the defining part points to 3-D reference.
Seems like a lot of work to get a value to change.

Looks like I might use a separate cell for just the day.
Probably easier to do that.

 

[T. Valko]

Try it like this...

Comparing SEP to AUG

Select the SEP sheet
Select cell N4

Format>Conditional Formatting
Formula Is:

=AND(COUNT(N4),DAY(N4)<DAY(INDIRECT("AUG!N4")))

 

[billz]

That worked.
thankyou much.

Try it like this...

Comparing SEP to AUG

Select the SEP sheet
Select cell N4

Format>Conditional Formatting
Formula Is:

=AND(COUNT(N4),DAY(N4)<DAY(INDIRECT("AUG!N4")))

 

[T. Valko]

You're welcome. Thanks for the feedback!