G
Guest
Guest
i have applied conditional formatting..to turn a date red if it is within 5 days of today...=(f6-TODAY())<6.....what formula do I use to change the color once the date is past today's date?
On 2002-03-10 08:19, Anonymous wrote:
i have applied conditional formatting..to turn a date red if it is within 5 days of today...=(f6-TODAY())<6.....what formula do I use to change the color once the date is past today's date?
On 2002-03-10 08:49, pinkcasp wrote:
Itried that , it didn't work.
On 2002-03-10 09:04, Aladin Akyurek wrote:
On 2002-03-10 08:49, pinkcasp wrote:
Itried that , it didn't work.
Lets take the problem step by step:
You have dates in F from F6 on. Do these dates change or fixed?
Aladin