Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how can I format a cell to change on a specific date
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how can I format a cell to change on a specific date
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 Singapore http://savefile.com/projects/236895 xdemechanik --- "ZC" wrote: 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how can I format a cell to change on a specific date
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") -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to change number to text with specific format in function | Excel Worksheet Functions | |||
Cell date format doesnt change | Excel Worksheet Functions | |||
Forcing a specific date format | New Users to Excel | |||
Change Excel cell format date type examples ("14-Mar-01") | Setting up and Configuration of Excel | |||
How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) |