| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make a conditional format recognize a formula in a cell | Excel Discussion (Misc queries) | |||
| Conditional format if a cell has a formula or if a percent or numb | Excel Discussion (Misc queries) | |||
| Conditional format formula | Excel Discussion (Misc queries) | |||
| Conditional Format Not Working | Excel Discussion (Misc queries) | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
Hybrid Mode
