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

--
Message posted from http://www.ExcelForum.com

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

--
Message posted from http://www.ExcelForum.com

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

--
Message posted from http://www.ExcelForum.com

On Thu, 2 Sep 2004 23:00:09 -0500, yh73090
wrote:

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

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.

"yh73090 <" wrote:

What I need is to add that if G11 and H11 are blank then make the
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.

Yo

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson

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

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

--
Message posted from http://www.ExcelForum.com