conditional formating for blank.

[Guest]

My formula is as follow:
L31=IF(OR(J31="",K31=""),"",(J31-K31)/J31). M31is the goal number.
I set a conditional formatting that if L31 is less than M31 the cell is fill
red and if L31 is greater than or equal to M31 it will be green. When J31 and
K31 is blank, L31 is appear green.

I have another formula.
L43=IF(OR(J43="",K43=""),"",SUM(J43:K43)). I set some condtional formatting.
However when J43 and K43 is blank, L43 turn appear as red.
Why the difference?

What I dont understand is

 

[Guest]

Try this to correct L31's cond formatting ..

Select L31, then set the CF formulas/formats as:

Cond1: =OR(L31="",M31="")
Format: Leave it as "No Format set"

Cond2: =L31<M31
Format: Red fill

Cond3: =L31>=M31
Format: Green fill

For L43, your question was left hanging in mid-air? <g>
But think it'll work ok if you try something along the same lines as for L31
above

I'd usually set it to trap for "" as the first condition
before going into the other numeric conditions