Hi Laurie,

Am Tue, 22 May 2012 15:29:37 +0000 schrieb LMDeWitt:

Column E lists the last audit date:
8/10/11 (needs to highlight)
5/26/11 (needs to highlight)
4/6/12
11/2/11

select column E = CF = Formula:
=AND(E10,E1<TODAY())


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2