how can I format a cell to change on a specific date

[Guest]

Can a cell that contains text, be formatted to change font color on a future
date? The column is reading "Active" in green to indicate that the contract
for that item is still valid, but I would like to change the "Active" to red
font, or possibly change the text to read "Inactive" in red. It's the color
of the font that's important, and the date that I want it to change on is on
9/11/08.

thanks for your help.

 

[Guest]

Try conditional formatting

Assume the data is in A1 down

Select col A (A1 active),
then apply conditional formatting using Formula is:
=AND(A1="Active",TODAY()>= --"11 Sep 2008")
Format the font to taste, ok out

The above will format only the cells in col A which contain the text
"Active" once the set "future" date: 11 Sep 2008 is reached. To test that the
CF works, just change the date to a current date, eg:
=AND(A1="Active",TODAY()>= --"15 Sep 2008")

And if you really want the format to trigger only for that specific date,
drop the ">", use instead:
=AND(A1="Active",TODAY()= --"11 Sep 2008")

Modify to suit ..

 

[Max]

Typo correction:

To test that the CF works,
just change the date to a current date, eg:
=AND(A1="Active",TODAY()>= --"15 Sep 2008")

The test formula should have read as (but of course<g>):
=AND(A1="Active",TODAY()>= --"15 Sep 2007")

---