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" wrote:

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
--
HTH,
Barb Reinhardt



"billz" wrote:

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.