Need help with "if" formula

[mizNRG]

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

 

[Eduardo]

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

 

[T. Valko]

Try this:

In Excel 2007

Select the range of cells. Assume this range is A1:A7
Goto Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use 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 Format>Conditional 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

 

[Jacob Skaria]

Say you have dates in A1 and B1

1. Select A1
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=A1<B1

4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK

If this post helps click Yes

 

[Jacob Skaria]

Say if you have your dates in cells A1 and B1

1. Select cell A1
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=A1<B1
4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK