Hi,
I am making a spreadsheet with due dates and completion dates on it. I want
to format the due dates to show up as on-time (green) or late (red) based on
today's date. Once the step is completed (a completed date is entered) I want
the color to stop changing based on today's date (and just stay the color it
was at time of completion.
Thanks

See http://www.xldynamic.com/source/xld.CF.html#due

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"MCouture" wrote in message
...
Hi,
I am making a spreadsheet with due dates and completion dates on it. I
want
to format the due dates to show up as on-time (green) or late (red) based
on
today's date. Once the step is completed (a completed date is entered) I
want
the color to stop changing based on today's date (and just stay the color
it
was at time of completion.
Thanks

Thanks for the link. I am able to get the formatting based on overdue status.
I am trying to get the formatting to stay the same after a completed date is
entered, or else all items will go red eventually, even if they were
completed on time.
Thanks


"Bob Phillips" wrote:

See http://www.xldynamic.com/source/xld.CF.html#due

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"MCouture" wrote in message
...
Hi,
I am making a spreadsheet with due dates and completion dates on it. I
want
to format the due dates to show up as on-time (green) or late (red) based
on
today's date. Once the step is completed (a completed date is entered) I
want
the color to stop changing based on today's date (and just stay the color
it
was at time of completion.
Thanks

I would make the test check that completion date is an overdue date.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"MCouture" wrote in message
...
Thanks for the link. I am able to get the formatting based on overdue
status.
I am trying to get the formatting to stay the same after a completed date
is
entered, or else all items will go red eventually, even if they were
completed on time.
Thanks


"Bob Phillips" wrote:

See http://www.xldynamic.com/source/xld.CF.html#due

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"MCouture" wrote in message
...
Hi,
I am making a spreadsheet with due dates and completion dates on it. I
want
to format the due dates to show up as on-time (green) or late (red)
based
on
today's date. Once the step is completed (a completed date is entered)
I
want
the color to stop changing based on today's date (and just stay the
color
it
was at time of completion.
Thanks