Date Conditional Format

[Guest]

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.

 

[Guest]

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

Regards,
Stefi



„jk†ezt írta:

 

[Guest]

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

 

[Guest]

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


„jk†ezt írta: