Conditional Formatting based on Today's Date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MCouture - 19 May 2008 17:44 GMT

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

Reply to this Message

Bob Phillips - 19 May 2008 18:04 GMT

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

Signature

HTH

Bob

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

> Hi,
> I am making a spreadsheet with due dates and completion dates on it. I
[quoted text clipped - 7 lines]
> was at time of completion.
> Thanks

Reply to this Message

MCouture - 19 May 2008 19:26 GMT

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

> See http://www.xldynamic.com/source/xld.CF.html#due
>
[quoted text clipped - 9 lines]
> > was at time of completion.
> > Thanks

Reply to this Message

Bob Phillips - 20 May 2008 14:46 GMT

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

Signature

HTH

Bob

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

> Thanks for the link. I am able to get the formatting based on overdue
> status.
[quoted text clipped - 20 lines]
>> > was at time of completion.
>> > Thanks

Reply to this Message