# expiry dates, conditional formatting, cell color changing?

#### vf750finterceptor

##### New Member
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.

### Excel Facts

To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
*bump*

bump

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()

same problem.

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

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!

Replies
2
Views
220
Replies
29
Views
925
Replies
7
Views
202
Replies
8
Views
378
Replies
3
Views
141

1,196,323
Messages
6,014,643
Members
441,834
Latest member
GHOSTOF309

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back