Conditional Formatting of blank/empty cells in Excel 2007

I'm new to Excel 2007, and I'm having some problems with conditional formatting. I have two columns of data, N and I. Some of the cells in column I are empty/blank, and the conditional formats are in column N. For example, if I2*1.05 is greater than the value of N2, I want N2 to be boldfaced red. If I2 is empty/blank, I want the format of N2 to be unchanged. The first conditional format, "if I2*1.05 is greater than N2, then the N2 value is boldfaced red" is easy, but what is the syntax for "if I2 is empty/blank, then leave N2 formating unchanged?"

Thank you.

Try:

=AND(I2<>"", I2*1.05>N2)

HTH

Jason

Thank you, Jason.

I'm still missing something. This is what I have entered as conditional formats:
Condition 1:
Formula: =AND(I2<>"", I2*1.05>N2)
Format: regular font, automatic color
Applies to: =$N$2:$N$138
Stop if True: not checked

Condition 2:
Cell Value: >I2*1.05
Format: bold font, red color
Applies to: =$N$2:$N$138
Stop if True: not checked

I still get the boldfaced red font in the cell in column N when the cell in column I is empty. Changing the order of these conditions doesn't help, nor does checking the Stop if True boxes.

What am I doing wrong here?

Thank you again - OverKnight

You only need one condition.

Condition1:

Formula Is: =AND(I2<>"", I2*1.05>N2)
Format: Bold red font

This is assuming that the "normal" format of the cell has automatic color, regular font.

HTH

Jason

That's the ticket...

Thank you, Jason.