Need help with "if" formula

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
 
E

Eduardo

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

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
 
J

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top