conditional format blank cell as a 4th condition?

[seanh1016]

I am already using conditions 1 and 2 and am down to my last condition. But I want to use 2 conditions hopefully combined into one.

I'm trying to say:
cell value=less than $A4-$B4 OR cell value is ""

Is this possible to combine into one?

 

[ctrlaltdel]

Try this

So, I assume it is another cell in which you are setting this conditional formatting? If so, try this (assume you are setting it in cell C4)

As your third conditional format select "formula is" from the first drop down. In the formula space enter =OR($C4 < $A4-$B4, $C4 = ""). Select the format you want and click ok.

Sound doable?

 

[seanh1016]

I meant to say:
only put a color if the cell value is less than $A4-$B4, no color if it is blank or 0.

I tried: formula is=AND(E4<$A4-$B4, E4<>"",E4=0). That isn't working. any thoughts?

E4 is the current cell

 

[seanh1016]

I got it:

form is=AND(D4<($A4-$B4),D4<>0,D4<>"")

works. thanks.