View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.setup
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Date Conditional Format

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


€žjk€ ezt Ã*rta:

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

"Stefi" wrote:

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.