If Statement Help

[yh73090]

What I need is to add that if G11 and H11 are blank then make th
cellcolor white.

=IF(OR(I$10>$H$11,I$10<$G$11),"",IF(I$10=$G$11,$G$11,$G$11+((I$10-$G$11)/$G$4)*$G$4))


Appreciate any help.

Y

 

[duane]

try format...conditional formatting and add the appropriate formul
=isblank(g11,h11) and specify format you wan

 

[yh73090]

This did not work, but rather than go that route. Could you give me
function for "If G11 and H11 are blank then make a range nofill.

I think this could be of more help rather than my first question.

Appreciate your assistance and sorry for the crazy way this is going.

Yo :roll

 

[Ron Rosenfeld]

If G11 and H11 are blank then make a range nofill

=IF(AND(ISBLANK(G11),ISBLANK(H11)),"","not blank")

entered in a cell will display a blank if H11 and G11 are both blank.



--ron

 

[Dave Peterson]

If you concatenate two blank cells, it'll be blank:

=(g11&h11="")

(as the conditional formatting formula)

Or
=(trim(g11&h11)="")

if you're afraid that anyone will hit the spacebar instead of clearing contents.

 

[duane]

this formula in the format condition seemed to work fine for me

=AND(ISBLANK(F12), ISBLANK(G12)