Hi Guys,

Using Excel 2000. I have a sheet that has dates of annual and bi-annual
certificates. I would like the font color to change if the date on the
sheet is expired. Can I set this up by column since some columns expire in
1 year and others in 2?

The other issue is that if the certificate date is 10/15/05, the actual
expiration date is at the end of the month for both 1 and 2 year renewals.

Thanks,
Linda