Date Conditional Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jk - 25 Sep 2006 13:20 GMT

I need a formula or code to apply into a cell that will flag a user if a
record is greater than 90 days from today. I have tried variations of IF
statements using the now function but have not been successful. Any
assistance would be appreciated.

Reply to this Message

Stefi - 25 Sep 2006 13:51 GMT

If record date is in column A, then try =TODAY()-A1<=90 as conditional
formatting formula for column A.

Regards,
Stefi

„jk” ezt írta:

> I need a formula or code to apply into a cell that will flag a user if a
> record is greater than 90 days from today. I have tried variations of IF
> statements using the now function but have not been successful. Any
> assistance would be appreciated.

Reply to this Message

jk - 25 Sep 2006 15:05 GMT

I invertedthe symbol to >=90 and now it works great.....thanks

> If record date is in column A, then try =TODAY()-A1<=90 as conditional
> formatting formula for column A.
[quoted text clipped - 8 lines]
> > statements using the now function but have not been successful. Any
> > assistance would be appreciated.

Reply to this Message

Stefi - 25 Sep 2006 15:17 GMT

Sorry, I was inattentive! Thanks for the feedback!
Stefi

„jk” ezt írta:

> I invertedthe symbol to >=90 and now it works great.....thanks
>
[quoted text clipped - 10 lines]
> > > statements using the now function but have not been successful. Any
> > > assistance would be appreciated.

Reply to this Message