conditional formating limits?

Can I put more than one if statement in a conditional
format?

I want it to turn a cells background yellow if one cell
has data and either of the other two are blank.

This is my base formula which works.
=IF(O100,IF(OR(ISBLANK($M$10),ISBLANK
($N$10)),"T","F"),"OK")


Here is what I tried to put into the conditional format
box. (It doesnt' work~ guess you know that already)

=IF(O100,IF(OR(ISBLANK($M$10),ISBLANK($N$10))))



Thanks,


Todd

Todd, instead of trying to fit it all in one you can have
up to three conditions in a conditional format box. this
way you can do one for O100
one for isblank(M10) and one for isblank(N10)

HTH
Kevin M
-----Original Message-----
Can I put more than one if statement in a conditional
format?

I want it to turn a cells background yellow if one cell
has data and either of the other two are blank.

This is my base formula which works.
=IF(O100,IF(OR(ISBLANK($M$10),ISBLANK
($N$10)),"T","F"),"OK")


Here is what I tried to put into the conditional format
box. (It doesnt' work~ guess you know that already)

=IF(O100,IF(OR(ISBLANK($M$10),ISBLANK($N$10)) ))



Thanks,


Todd
.

Todd,
I have always used the functions to return TRUE and FALSE when I do conditional formatting. I changed your formula a little becuase you can actually put all three conditions into your OR statement.

=IF(OR(O100,ISBLANK($N$10),ISBLANK($M$10)),TRUE( ),FALSE())

Hope This Helps,
Mark

----- Todd wrote: -----

Can I put more than one if statement in a conditional
format?

I want it to turn a cells background yellow if one cell
has data and either of the other two are blank.

This is my base formula which works.
=IF(O100,IF(OR(ISBLANK($M$10),ISBLANK
($N$10)),"T","F"),"OK")


Here is what I tried to put into the conditional format
box. (It doesnt' work~ guess you know that already)

=IF(O100,IF(OR(ISBLANK($M$10),ISBLANK($N$10))))



Thanks,


Todd