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.