Conditional formattind with dates

[Guest]

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

 

[Roger Govier]

Hi Bama

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

Regards

Roger Govier

 

[Guest]

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

 

[Guest]

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

 

[Roger Govier]

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
Format>Conditional 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