I have a worksheet that keeps track of our coaches certifications. There are
three columns which contain dates (specifically columns g, h & I) I would
like to be able to have excel automatically scan those columns and highlight
cells that are equal to or lesser than a specific date. This function should
also allow me to change the date several times a year. Can someone suggest
the easiest way of performing that task? I have provided an example below.

Name Sport First Aid CPR Permit
John Doe Soccer 10/31/07 10/31/08 12/11/09
Jane Doe Basketball 03/10/08 04/19/07 11/05/06
I would like to automatically highlight dates that are equal to or prior to
10/31/07.