Hi Bama

Supposing your date is in A1, then the conditional format should be set to
Formula Is =TODAY()-A1<=5

Regards

Roger Govier


bama wrote:
Reviewed some threads and still got me lost...what i am trying too do is get
an cell to high lite when an item is coming due within 5 days of the current
date....IE; today would be the 23 sep want an item to high-light when its
with-in that window....any help would be appreciated.

Bama