Please follow following steps
1.Set the cells A1 and A2 to display date format as:-
select the cell right click format cells number tab select date
from category list select 03/14/01 from type list click ok
2.Now select A2 and click formatconditional formatting from the toolbar
3.In the dialog box, select cell value is from the left drop down list
4.select between from the middle drop down list
5.enter =$A$1 in the box to the between drop down list
6. enter =DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)) to the last box
7.click format button and choose your color
8. click ok

Now you are done!......



Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

--
Message posted via http://www.officekb.com