Date Conditional Format jk 25.09.2006 12:20:02 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.

RE: Date Conditional Format Stefi 25.09.2006 12:51:02 If record date is in column A, then try =TODAY()-A1<=90 as conditional formatting formula for column A. Regards, Stefi „jk” ezt írta: [Quoted Text] > 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. > >

RE: Date Conditional Format jk 25.09.2006 14:05:02 I invertedthe symbol to >=90 and now it works great.....thanks "Stefi" wrote: [Quoted Text] > 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. > > > >

RE: Date Conditional Format Stefi 25.09.2006 14:17:01 Sorry, I was inattentive! Thanks for the feedback! Stefi „jk” ezt írta: [Quoted Text] > 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. > > > > > >