I want the date that is in cell F5 to turn yellow when its within 5 days of
the date in A1..................

"bama" wrote:

Thanks for the reply...tried it but it turned everything yellow.......My
current daily date is in A1, but when i have a date in cell F5 read say like
29 sep and the current date is 23 sep i want it to highlite yellow when its
within 5 days IE; turn yellow on the 28 sept.....Hope this clears it up much
better...

Bama

"Roger Govier" wrote:

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