Conditional Formatting of date

[JohnButt]

I have a field named PTS DC

It is formatted as a date and an expiry date of 01/06/2009 has been inserted.

I am trying to apply a conditional format so that when there are 60 days to
its expiry it will change the background to red.

I have searched the discussion group and have tried several methods without
any success.

Can anyone help - thanks in anticipation

 

[John W. Vinson]

I have a field named PTS DC

It is formatted as a date and an expiry date of 01/06/2009 has been inserted.

I am trying to apply a conditional format so that when there are 60 days to
its expiry it will change the background to red.

I have searched the discussion group and have tried several methods without
any success.

Can anyone help - thanks in anticipation

On the conditional formatting menu use "Expression Is" and in the expression
window type

< DateAdd("d", 60, Date())

and set the color to red.