Colouring in advance dates

[Elvey Middleton]

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

 

[Bob Phillips]

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)