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.

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.

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.

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.

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.

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.