Need help with "if" formula

  • Thread starter Thread starter mizNRG
  • Start date Start date
M

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
 
Hi,
use conditional formating, highlight cell rules, greater than, select the
column where you have the date to compare
 
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
 
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
 
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
 
Back
Top