|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 25th, 2006, 01:20 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
Date Conditional Format
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. 
|
|
#2
September 25th, 2006, 01:51 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Date Conditional Format
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.
|
|
#3
September 25th, 2006, 03:05 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Date Conditional Format
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.
|
|
#4
September 25th, 2006, 03:17 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
