AND, ISBLANK, CONDITIONAL FORMAT

[srizki]

I need a formula to use in conditional formatting. I need to highlight cells if the corresponding cell has number and the next cell is blank.
So for example A2, A3, A4, A5, A6 have numbers, and B2, B4, B5, have codes like A, I, C, so since A3 has the number but B3 is empty I want to highlight this, something like =AND(ISNUMBER($A2,ISBLANK(B2)….
Something like this.

=AND(IF($I64<>"",$J64="")) does not work because it highlight even when there is text.

Lockbox Template July 2007.xls
	I	J	K	L
115	381383.5	K
116	93095.86	J
117	935036.14	A
118	121135.55	I
119	31740.62	E
120	0.01	M
Sheet1

 

[Andrew Poulsom]

Is it?

=AND(ISNUMBER(A2),ISBLANK(B2))

 

[srizki]

Thank you Andrew, it is what I was looking for.
Cheers.
Sohail