View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nannybears nannybears is offline
external usenet poster
 
Posts: 7
Default 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.