I'm sorry I'm not real computer literate, can you tell me how exactly to
write I keep getting errors.

"SteveW" wrote:

Use conditional formatting

a2 = start date
b2 = due date

in b2 add conditional format
=if(b2<today(),1,0)
Format as required.

Steve



On Thu, 25 Jan 2007 04:21:01 -0000, j wrote:

I have a similiar question except that I have two columns. One with a
start
date, the second column automatically updates to show a date 30 days from
that date something is due. What I'm trying to do is change the color of
that column to red after the 30 days have expired to show these
personnel are
over due.

"tstorie" wrote:

I am tracking expiration dates for training. With numerous people
working
for me, tracking their training is vital, and the easiest view for all
training classes required is on Excel. I am wondering if Excel can
automatically change the color of a date that I input as the expiration
date
approaches and as it passes.

I appreciate any help. If it is capable of doing this task, I cannot
find
how to do it.