Hi Guys
Can you help me, I wish to input a date in one column and have
a date six months ahead in the next column.
I then want the date to change colour depending on the date i.e. if the date
was 120 days from the original date it would be green and if it was 150 days
from the original date it would turn red.


Any help would be appreciated

Thanks


Elvey

Look at conditional formatting. Debra has a decent starter page at
http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Elvey Middleton" <(E-Mail Removed)> wrote in message
news:%23myed$(E-Mail Removed)...
> Hi Guys
> Can you help me, I wish to input a date in one column and
have
> a date six months ahead in the next column.
> I then want the date to change colour depending on the date i.e. if the
date
> was 120 days from the original date it would be green and if it was 150
days
> from the original date it would turn red.
>
>
> Any help would be appreciated
>
> Thanks
>
>
> Elvey
>
>