Conditional Formatting based on Today's Date

[MCouture]

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

 

[Bob Phillips]

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]

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]

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)