Try this:

In Excel 2007

Select the range of cells. Assume this range is A1:A7
Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format
Enter this formula in the box below:
=A1<B1
Click the Format button
Select the desired style(s)
OK out

In Excel versions 2003 and earlier

Select the range of cells. Assume this range is A1:A7
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=A1<B1
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"mizNRG" wrote in message
...
I need an if formula that will change the font color of a cell to red if
the
date within the cell is less than the date in another cell. Basically, in
the example below I'd like the 6/24/09 to turn red to indicate that it was
overdue.

Example:

Due Date Date Entered
6/24/09 7/8/09

If anyone can help me out with this I'd really appreciate it!
Thanks