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
Bookmarks