Filter rules for date type

Is there anyway to set the rules for the view such that the view wil
display field1(type is date) row in RED when field1 is 10 days late
from TODAY??
In my automatic setting rules condition, I put:
'Field1' 'Between' 'Today and 10 days later'
This condition ONLY works for if today is 04/27/04.

I wanted to display all item that are btw 'Today and 10 days later' i
RED. those not within this range will remain in black color. Once m
system date changes, it shld oso change from 04/27/04 to 05/07/04, To
04/28/04 to 05/08/04.

Instead, it still display only till 05/07/04.

How do I set it such that it's able to reflect the correct date once m
system date changes??
Pls advice. Thank

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com