How do I write formula to conditional format using =if(and(or)
 

I need to compare the values in two cells, A1 and B1, I wish to put the
conditional formating on cell b1.

I need to determine if A1<0 and B10 or if A10 and B1<0.

If either of these two conditions occur, I need the cell of b1 to turn yellow.

I have tried using =if(and(a1<0,b10), =if(or(and(a10,b1<0), ???????

Any assistance would be appreciated.

Thanks! Don

How do I write formula to conditional format using =if(and(or)
 

try:

Formula is: =OR(AND(A1<0,B10),AND(A10,B1<0))

HTH

"Don from Missouri" wrote:

I need to compare the values in two cells, A1 and B1, I wish to put the
conditional formating on cell b1.

I need to determine if A1<0 and B10 or if A10 and B1<0.

If either of these two conditions occur, I need the cell of b1 to turn yellow.

I have tried using =if(and(a1<0,b10), =if(or(and(a10,b1<0), ???????

Any assistance would be appreciated.

Thanks! Don

How do I write formula to conditional format using =if(and(or)
 

try
=A1*B1<0

"Don from Missouri" wrote:

I need to compare the values in two cells, A1 and B1, I wish to put the
conditional formating on cell b1.

I need to determine if A1<0 and B10 or if A10 and B1<0.

If either of these two conditions occur, I need the cell of b1 to turn yellow.

I have tried using =if(and(a1<0,b10), =if(or(and(a10,b1<0), ???????

Any assistance would be appreciated.

Thanks! Don

How do I write formula to conditional format using =if(and(or
 

This solution is so simple, yet it is brilliant and obvious. Thank you ever
so much!

Don

"bj" wrote:

try
=A1*B1<0

"Don from Missouri" wrote:

I need to compare the values in two cells, A1 and B1, I wish to put the
conditional formating on cell b1.

I need to determine if A1<0 and B10 or if A10 and B1<0.

If either of these two conditions occur, I need the cell of b1 to turn yellow.

I have tried using =if(and(a1<0,b10), =if(or(and(a10,b1<0), ???????

Any assistance would be appreciated.

Thanks! Don

How do I write formula to conditional format using =if(and(or
 

Thank you for your response. This solution did not work. Perhaps I mis
kedyed it. Another response of =A1*b1<0 did work.
Thank you for your response.

Don

"Toppers" wrote:

try:

Formula is: =OR(AND(A1<0,B10),AND(A10,B1<0))

HTH

"Don from Missouri" wrote:

I need to compare the values in two cells, A1 and B1, I wish to put the
conditional formating on cell b1.

I need to determine if A1<0 and B10 or if A10 and B1<0.

If either of these two conditions occur, I need the cell of b1 to turn yellow.

I have tried using =if(and(a1<0,b10), =if(or(and(a10,b1<0), ???????

Any assistance would be appreciated.

Thanks! Don