Using a pop up window as a reminder

Need more info. What 'add a reminder date field to recontact a person' means?

I have a customer table and each customer has a number of leads for conference bookings. Because the lead table can be quite lengthy I want to set a reminder to contact the person closer to the date if they haven't accepted our quote yet. It would be great if when I logged into the system every day a pop up window would come up with my reminders set for that day of whom to recontact. This will save me a lot of time instead of wading through all the records to see who to contact

Okay, makes better sense.
I would not suggest to display any sort of popups - might be annoying for the end user. My suggestion is to sort your data the way that expiring or expired records appear at the top of the list and also apply color coding i.e. change the background of expired records to red.
Here is the article that explains how to apply formatting to rows and separate fields:

http://xlinesoft.com/blog/2011/01/03/tutorial_conditional_formatting/

Thank you for the link I will have a look at formating rows, it could work. I suppose I would make the condition date()>'requireddate' make the line red.
At the moment I got it sorted by date and also priority

Can someone please help me with the syntax for the above example. I am trying to set the condition that if the reminder date > today's date then make record red
if ($date['Reminder Date'] > date()) {

$color="black";

} else {

$color="red";

}

$value="<span style='color: " . $color . ";'>$value</span>";

$date['Reminder Date'] doesn't make much sense to me. I don't know what you meant to put there but $date['Reminder Date'] simply won't work.
Where do you put this code?

I am following the example in the link above http://xlinesoft.com/blog/2011/01/03/tutorial_conditional_formatting/ but am struggling with the syntax for comparing a reminder date in my leads table to todays date.

I've managed to figure it out, thanks
if ($value > now()) {

$value =$value. ' <img src="green.png" alt="" />';

$color="black";

} else {

$value ='<strong>'.$value. '</strong> <img src="red.png" alt="" />';

$color="red";

}

$value="<span style='color: " . $color . ";'>$value</span>";