Hi Greg Glynn

I'm really bad in programming... may I know what codes i can provide under
the "Do stuff" section and how do i go about inserting the set of codes u'd
provided earlier? Click on the relevant worksheet tab and paste in "View
Code" or select the expiry date column and select Macro -- Visual Basic
Editor?!

Thank you!

"Greg Glynn" wrote:

2) How to extract the particular row of information in the spreadsheet

together with the heading of the spreadsheet and send to the relevant
party
for further action when the expiry date is nearing?

If you choose to use conditional formatting as suggested, you can then
interrogate a range to a color attribute to identify the records.

For each c in Range("Your range")
If c.font.colorindex = 5 'For change in Font Color to Red
Do stuff
End With
Next

For each c in Range("Your range")
If c.font.Interior.colorindex = 5 'For change in Cell Background
Color to Red
Do stuff
End With
Next

3) How to send the row of information as an email to the relevant
party?
Check out Ron de Bruin's Excellent "SendMail" add-in.