I want format cells to have expiry dates & highlight

  • Thread starter Thread starter Aims
  • Start date Start date
A

Aims

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?
 
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
 
Back
Top