Home |
Search |
Today's Posts |
#1
|
|||
|
|||
worksheet cell color change
i need to make a cell with an expiration date change colors after that date
has passed. example: I have a cell with 04/11/05 and I need to make that cell font turn from black to red after that date has passed. |
#2
|
|||
|
|||
Have a look at
formatconditional format -- Don Guillett SalesAid Software "jimemma" wrote in message ... i need to make a cell with an expiration date change colors after that date has passed. example: I have a cell with 04/11/05 and I need to make that cell font turn from black to red after that date has passed. |
#3
|
|||
|
|||
Hi
Use CF See Debra's site for a example http://www.contextures.com/xlCondFormat01.html -- Regards Ron de Bruin http://www.rondebruin.nl "jimemma" wrote in message ... i need to make a cell with an expiration date change colors after that date has passed. example: I have a cell with 04/11/05 and I need to make that cell font turn from black to red after that date has passed. |
#4
|
|||
|
|||
You can use FormatConditional Formatting for this.
Click on the cell and CFCell Value is: greater than 4/11/2005 FormatFontRed Note: the value will change to 38453 from 4/11/2005 if you back in to alter. Gord Dibben Excel MVP On Tue, 12 Apr 2005 14:39:58 -0700, "jimemma" wrote: i need to make a cell with an expiration date change colors after that date has passed. example: I have a cell with 04/11/05 and I need to make that cell font turn from black to red after that date has passed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Worksheet Tab Name into a cell address | Excel Discussion (Misc queries) | |||
How can I link a cell in one worksheet to a cell in another works. | Excel Worksheet Functions | |||
enable a scrolling cell with lengthy text within a worksheet? | Excel Discussion (Misc queries) | |||
Excel cell references to 2nd worksheet stopped working | Excel Worksheet Functions | |||
Worksheet reference (i.e placing worksheet name in a cell) | Excel Worksheet Functions |