| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date in numeric format | New Users to Excel | |||
| Date Format Problems?? | Excel Discussion (Misc queries) | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
| Conditional Format With SUMIF | Excel Worksheet Functions | |||
Linear Mode
