Hi Jade,

Am Tue, 19 Jun 2012 15:06:59 +0000 schrieb Jade Summers:

I am creating a database at work for expiry of various programs/courses.
I have got that conditional formatting down but I am struggling to make
D2 (if pers has course) change to yes, No, or expired depending on the
dates. I have got it to say yes, and expired but the "No" part when no
date is inserted in column E.

try:
=IF(E4=0,"No",IF(E4<=TODAY(),"Expired","Yes"))


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