Date formulas

[Rusty]

I'm trying to conditional format some cells. I want to change the color of
the font after a certain amount of days. The cell is a date I need it to
change after it is >4 but <6 and to change again when it >6. If someone
could helpit would I would be greatfull.
Thank you,
Rusty

[Don Guillett]

something like this
format>conditional format>condition 1>formula is>=a4>a2+6
format>conditional format>condition 2>formula is>=a4>a2+4

--
Don Guillett
SalesAid Software
donaldb@281.com
"Rusty" <rdailey@grandecom.net> wrote in message
news:114iii5oge8hoab@corp.supernews.com...
> I'm trying to conditional format some cells. I want to change the color of
> the font after a certain amount of days. The cell is a date I need it to
> change after it is >4 but <6 and to change again when it >6. If someone
> could helpit would I would be greatfull.
> Thank you,
> Rusty
>
>

[Rusty]

I guess that I'm lost. I tried to use this and it didn't work.



"Don Guillett" <donaldb@281.com> wrote in message
news:ezQCZ2FNFHA.3960@TK2MSFTNGP12.phx.gbl...
> something like this
> format>conditional format>condition 1>formula is>=a4>a2+6
> format>conditional format>condition 2>formula is>=a4>a2+4
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> "Rusty" <rdailey@grandecom.net> wrote in message
> news:114iii5oge8hoab@corp.supernews.com...
>> I'm trying to conditional format some cells. I want to change the color
>> of
>> the font after a certain amount of days. The cell is a date I need it to
>> change after it is >4 but <6 and to change again when it >6. If someone
>> could helpit would I would be greatfull.
>> Thank you,
>> Rusty
>>
>>
>
>