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.