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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Past due function
The below link should help
http://www.contextures.com/xlCondFormat01.html If this post helps click Yes --------------- Jacob Skaria "nannybears" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Past due function
Hi,
You haven't told us what conditions you want to use to color code the entries, not which ones you want to color code - just those past due, and the whole row or just the past due cell? Something like this: To conditionally format your cell(s): In 2003: 1. Select the cells you want to format (column C) 2. Choose Format, Conditional Formatting 3. Choose Cell Value Is from the first drop down 4. In the second box choose greate than 4b. In the third box enter 10 5. Click the Format button 6. Choose a color on the Patterns tab (or any available option) 7. Click OK one. 8. Click Add 9. For Condition 2, from the first drop down pick Cell Value is 10. In the second box pick greater than 10b. In the 3rd box enter 20 11. Click the Format button 12. Choose a color and click OK twice. .... Max of 3 condtions in 2003. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "nannybears" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Past due function
Hi,
Please ammend my previous suggestion by reversing the order of the numbers, the first condition should be greater than the largest number, and each successive one a smaller number. In other words 30 20 10 Would be the correct order. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Shane Devenshire" wrote: Hi, You haven't told us what conditions you want to use to color code the entries, not which ones you want to color code - just those past due, and the whole row or just the past due cell? Something like this: To conditionally format your cell(s): In 2003: 1. Select the cells you want to format (column C) 2. Choose Format, Conditional Formatting 3. Choose Cell Value Is from the first drop down 4. In the second box choose greate than 4b. In the third box enter 10 5. Click the Format button 6. Choose a color on the Patterns tab (or any available option) 7. Click OK one. 8. Click Add 9. For Condition 2, from the first drop down pick Cell Value is 10. In the second box pick greater than 10b. In the 3rd box enter 20 11. Click the Format button 12. Choose a color and click OK twice. ... Max of 3 condtions in 2003. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "nannybears" wrote: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Past due function
Shane - I'm not where I can try your suggestion - Also, the version I am
using is Office 2007 if that makes any difference. I will definitely try this later today and reply if it helps or post further questions. Thanks to all respondants. This site is heaven sent... "Shane Devenshire" wrote: Hi, Please ammend my previous suggestion by reversing the order of the numbers, the first condition should be greater than the largest number, and each successive one a smaller number. In other words 30 20 10 Would be the correct order. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Shane Devenshire" wrote: Hi, You haven't told us what conditions you want to use to color code the entries, not which ones you want to color code - just those past due, and the whole row or just the past due cell? Something like this: To conditionally format your cell(s): In 2003: 1. Select the cells you want to format (column C) 2. Choose Format, Conditional Formatting 3. Choose Cell Value Is from the first drop down 4. In the second box choose greate than 4b. In the third box enter 10 5. Click the Format button 6. Choose a color on the Patterns tab (or any available option) 7. Click OK one. 8. Click Add 9. For Condition 2, from the first drop down pick Cell Value is 10. In the second box pick greater than 10b. In the 3rd box enter 20 11. Click the Format button 12. Choose a color and click OK twice. ... Max of 3 condtions in 2003. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "nannybears" wrote: 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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Past due function
THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU. You have no idea the
amount of time I have tried to figure this out! Oofda - how much easier could it be? "Shane Devenshire" wrote: Hi, Please ammend my previous suggestion by reversing the order of the numbers, the first condition should be greater than the largest number, and each successive one a smaller number. In other words 30 20 10 Would be the correct order. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Shane Devenshire" wrote: Hi, You haven't told us what conditions you want to use to color code the entries, not which ones you want to color code - just those past due, and the whole row or just the past due cell? Something like this: To conditionally format your cell(s): In 2003: 1. Select the cells you want to format (column C) 2. Choose Format, Conditional Formatting 3. Choose Cell Value Is from the first drop down 4. In the second box choose greate than 4b. In the third box enter 10 5. Click the Format button 6. Choose a color on the Patterns tab (or any available option) 7. Click OK one. 8. Click Add 9. For Condition 2, from the first drop down pick Cell Value is 10. In the second box pick greater than 10b. In the 3rd box enter 20 11. Click the Format button 12. Choose a color and click OK twice. ... Max of 3 condtions in 2003. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "nannybears" wrote: 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. |
Reply |
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) |