Hi,
use conditional formating, highlight cell rules, greater than, select the
column where you have the date to compare

"mizNRG" wrote:

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