Conditional Formatting of date


J

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
 
Ad

Advertisements

J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top