Conditional formattind with dates
 

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

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

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

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

Hi Bama

I'm not sure whether your problem is because you are using A1 to hold todays
date, or whether it is colouring cells which have gone past the current date.

If you are holding the current date in A1, then you don't need to use
TODAY() as part of the formula. Change to the following.

Highlight the cells in column F, and with the cursor in F1
FormatConditional Formatting Formula Is =AND(F1-A1<=5,F1-A1=0)

This will take the colouring off, once the date is past today's date.


Regards

Roger Govier


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