expiry dates, conditional formatting, cell color changing?

[vf750finterceptor]

Hi, newbee here.
Fairly new at excel as well. I think I know enough to confuse myself.
I am looking to use conditional formatting to highlight a cell when an items exipry date is 60days 30 days and finally past due. I can get the cell to change with this formula:

=a1 lessthan today()-60

my problem is that when i get the block to change on the first condition (blue) I cannot get it to turn yellow for the second condition

=a1 lessthan today()-30

or red for past expiry

(not sure of this formula but) =a1 lessthan today()-0

Could someone please whip up the proper formula for me as I think this is where my problem is or suggest what I am doing wrong.
I am using the symbol for "less than" but for some reason this bulletin board does not recognize the symbol so I have spelled it out.
thanks.

 

[vf750finterceptor]

*bump*

bump

 

[Lakelands01]

If I understand this problem correctly, I can suggest you use three conditions in the conditional formattiing.

Condition 1 is Cell Value Is Less Than =Today()-60

Condition 2 is Cell Value Is Less Than = Today()-30

Condition 3 is Cell Value Is Less Than = Today()

 

[vf750finterceptor]

same problem.

Thanks for the quick reply.
However, i have the same problem. The cell turns the original color (blue) and will not change to yellow or red if I manipulate the date entered in the cell.
It's like excel sees the first condition and will not change the cell color if other conditions are met.
Are the conditions in order of priority (ie 1st condition overrides 2 and 3)?
Man, I'm going to harass work to put me on an excel course if they expedt me to keep up with this!

cheers

 

[vf750finterceptor]

think i got it

aha!
Changed the order of the conditions and it seems to work!
I'm going to hassle my boss toorrow until I get the excel course. You just have to love it when the dump this stuff on you and just expect you to know how to do it.

thanks for the help!