I want format cells to have expiry dates & highlight
 

Is there a way in excel that i can put a date in a cell and have it
automatically highlight to show its expiring at a certain time period,
whether it be 1 or 2 years later?

I want format cells to have expiry dates & highlight
 

You could try conditional formatting

An example ...
Assume A2 contains a real date: 5-May-2008
Assume dates which are = 6 months and < 12 months old
are to be formatted in brown fill (1 month is assumed = 30 days)

Select A2, click Format Conditional formatting,
then apply it in Condition 1 using Formula Is:
=AND(A2<"",TODAY()-$A$2=180,TODAY()-$A$2<360)
Format Brown fill OK out

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Aims" wrote:
Is there a way in excel that i can put a date in a cell and have it
automatically highlight to show its expiring at a certain time period,
whether it be 1 or 2 years later?