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

Need help with "if" formula
 

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

Need help with "if" formula
 

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