conditional formating limits?

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

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(O10<>0,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(O10<>0,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 O10<>0
one for isblank(M10) and one for isblank(N10)

HTH
Kevin M
 
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(O10<>0,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(O10<>0,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(O10<>0,IF(OR(ISBLANK($M$10),ISBLANK($N$10))))



Thanks,


Todd
 
Back
Top