several conditional formats for dates

[Dana]

I have an expiration date that I have conditioned to turn red after the date
with "cell value" "is less than or equal to" =TODAY()
It turns blue if "cell value" "is greater than" =TODAY().

I want it to turn green 90 days before it expires. I tried "cell value"
"between" =TODAY()-1 and =TODAY()<90 but it if it is not past the
date it turns green no matter how far away the date.

I have to have this in one cell and can't reference another cell. Your help
would be greatly appreciated.

Thanks,

Dana

 

[Sheeloo]

Choose FORMULA IS and use
=A1<(TODAY()-90) for GREEN
=A1<Today() for BLUE
=A1>Today() for RED

For first you have to use FORMULA IS. For others you can continute to do
what you are doing.

Remember that in Excel 2003 and earlier versions, Conditional Formatting
stops when any conditon is TRUE. That means if first conditon is TRUE it will
be applied even if SECOND or/and THIRD is/are also true

 

[Dana]

Thank you. I think that is my problem. I am working with 2003. I guess
I'll just keep the 2 conditions. I appreciate your help.

 

[Dana]

Actually that helped alot. Once I realized I could only use 2 conditions I
changed them to after the expiration date and within 90 days of the
expiration date (using the between) then I changes my font to the third
color, so it shows when the other two conditions are not met. Thanks for the
help.

 

[Sheeloo]

Dana,

Glad it worked out.
Pl. note that you can have 3 conditions with conditional formatting. As
figured out by you you can have the 4th format when none of the three are
true.

You can also have 3 more by using cell FORMATTING...