Hi,

I have been asked to create a spreadsheet with three columns Status - Qualified Date - Expired Date.

The Status column shows a green box with "Status" written in it

The Qualified date column is filled with dates.

I need to know how to program the Exipred Date column to show the date 6 onths later from the Qualified date Column.

and when a column reaches the date 6 month's on, for the status box to turn red with "expired written in it.

Can this be done and if so, could someone show me please.

Thanks