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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ZC - 14 Sep 2007 19:48 GMT

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.

Reply to this Message

Max - 15 Sep 2007 00:16 GMT

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 ..

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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
[quoted text clipped - 4 lines]
>
> thanks for your help.

Reply to this Message

Max - 16 Sep 2007 01:07 GMT

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")

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message

Rate this thread: