Conditional Formatting

[LMR175]

I have a sheet that has a column labeled "Date Ticket Out" and what I want to do is use conditional formatting to change the color when the date the ticket is enter exceeds 3 & 5 days.

Basically what Im doing right now is "cell value is greater or equal to and I pick the same cell I originally insert the ticket date out is. Is this wrong? Another words, I enter say 4/1/11 and in 3 days the cell turns green and after 5 days it turns red.

 

[jmthompson]

Highlight cells less than =NOW()-3 set up format for green

Highlight cells less than =NOW()-5 set up format for red

On your ticket out column

 

[Brian from Maui]

Using Formula Is,

Try as the 1st condition

=TODAY()-A1 > 5

Second condition

=TODAY()-A1 > 3

Where A1 is the cell that houses the date entered

 

[LMR175]

Some reason I cannot get either one of those to work

 

[Brian from Maui]

What have you tried?

 

[LMR175]

What have you tried?

I tried yours and I entered as you stated and it does not change. Lets say I put in todays date 4/5/11 and I change the date on my system to the 12th, the cell does not change to red as needed. Do I need to create an additional cell for the formatting? I think I got myself lost in this.

 

[RSXchin]

Is there a chance that you need to change your date formatting for that cell?

 

[LMR175]

Is there a chance that you need to change your date formatting for that cell?

Not sure I understand what your asking... Basically, it's a cell in a column that is labeled "Date Ticket Out", when we issue a job ticket to the field, we would enter the date we issued it in the cell and in 5 days I would like that cell to turn red to alert our staff that it needs attention.

 

[RSXchin]

right click on the cell you put the date into
format cells...
date
choose the one you want
?????
PROFIT!!!!

 

[LMR175]

right click on the cell you put the date into
format cells...
date
choose the one you want
?????
PROFIT!!!!

Yes I have done that, but the "conditional" formatting is not working.