Need help with "if" formula
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
|