View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mizNRG mizNRG is offline
external usenet poster
 
Posts: 2
Default 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