G
Guest
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 B1>0 or if A1>0 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,b1>0), =if(or(and(a1>0,b1<0), ???????
Any assistance would be appreciated.
Thanks! Don
conditional formating on cell b1.
I need to determine if A1<0 and B1>0 or if A1>0 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,b1>0), =if(or(and(a1>0,b1<0), ???????
Any assistance would be appreciated.
Thanks! Don