Conditional Formatting of date

  • Thread starter Thread starter JohnButt
  • Start date Start 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
 
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
Click to expand...

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

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

and set the color to red.
 
Back
Top