Hi,

Do you mean things exactly 14, 24 and 36 overdue or do you mean 14-23,
24-36, 36?

Let's assume the first, and that the numbers are in column A, you didn't
give us any idea what your data looks like,

Highlight all the rows of data you want formatted and then
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 Formula is from the first drop down
4. In the second box enter the formula:
=$A1=14
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 Formula is
10. In the second box enter the formula:
=$A1=24
11. Click the Format button
12. Choose a color and click OK twice.

repeat for the third condition.
=$A136

In 2007:
1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, Manage Rules, New Rule
3. Choose Use a formula to determine which cell to format
4. In the Format values where this formula is true enter the following
formula:
=$A1=14
5. Click the Format button and choose a format.
6. Click OK twice
7. New Rule
8. Choose Use a formula to determine which cell to format
9. In the Format values where this formula is true enter the following
formula:
=$A1=24
10. Click the Format button and choose a format.
11. Click OK tree times.

repeat for a 3rd condtion

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Conditional Formula Writing (for dates)" wrote:

Trying to figure out the formula for conditional formatting to highlight
dates (and that entire row) for 14, 24, 36+ days overdue. Each time
increment would need it's own formatting.

Any help would be appreciated.

Thanks