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.