| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Past due function
I have 4 columns with a name (Joe Customer), due date (5/10/09), promise pmt
date (5/20/09), days past due (10). Can I do this with conditional formatting only? I would then like to color code the cells in the "days past due" column depending on the number of days past due. I'm really a novice with formulas and very frustrated with this...thanks for any and all help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Past 30 montha | Charts and Charting in Excel | |||
| Copy and Past | Excel Discussion (Misc queries) | |||
| get past one problem, and run across another | Excel Discussion (Misc queries) | |||
| Date/If function for past dues | Excel Worksheet Functions | |||
| Past Value automatically | Excel Discussion (Misc queries) | |||
Threaded Mode
