If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Format
I'm wanting to shade a cell if 2 conditions are true. They problem I am
having is that one of the cells uses the VLOOKUP function. I can get the cell to change colors if I specify just one condition. Example: =AND(B4=F277,B6=0). I want a range of cells to be specified. When I try this, the condition doesnt work. Such As: =AND(B4=F277:F284,B6=0). I've even tried: =AND(B4=$F$277:$F$284,B6=0). How can I specify a range of cells in a conditional format? Should I be using an IF statement? |
#2
|
|||
|
|||
Conditional Format
Select F277:F284
Conditional Formatting =AND($B$4=$F277,$B$6=0) "Randy" wrote: I'm wanting to shade a cell if 2 conditions are true. They problem I am having is that one of the cells uses the VLOOKUP function. I can get the cell to change colors if I specify just one condition. Example: =AND(B4=F277,B6=0). I want a range of cells to be specified. When I try this, the condition doesnt work. Such As: =AND(B4=F277:F284,B6=0). I've even tried: =AND(B4=$F$277:$F$284,B6=0). How can I specify a range of cells in a conditional format? Should I be using an IF statement? |
#3
|
|||
|
|||
Conditional Format
I'm not totally clear what your test is supposed to be. Does this do what
you want? =AND(COUNTIF(F277:F284,B4)0,B6=0) -- Rick (MVP - Excel) "Randy" wrote in message ... I'm wanting to shade a cell if 2 conditions are true. They problem I am having is that one of the cells uses the VLOOKUP function. I can get the cell to change colors if I specify just one condition. Example: =AND(B4=F277,B6=0). I want a range of cells to be specified. When I try this, the condition doesnt work. Such As: =AND(B4=F277:F284,B6=0). I've even tried: =AND(B4=$F$277:$F$284,B6=0). How can I specify a range of cells in a conditional format? Should I be using an IF statement? |
#4
|
|||
|
|||
Conditional Format
That works great, but i should have been more specific. I want cell B6 to be
shaded. Sorry for not saying that in my first post. "Teethless mama" wrote: Select F277:F284 Conditional Formatting =AND($B$4=$F277,$B$6=0) "Randy" wrote: I'm wanting to shade a cell if 2 conditions are true. They problem I am having is that one of the cells uses the VLOOKUP function. I can get the cell to change colors if I specify just one condition. Example: =AND(B4=F277,B6=0). I want a range of cells to be specified. When I try this, the condition doesnt work. Such As: =AND(B4=F277:F284,B6=0). I've even tried: =AND(B4=$F$277:$F$284,B6=0). How can I specify a range of cells in a conditional format? Should I be using an IF statement? |
#5
|
|||
|
|||
Conditional Format
Yes! That works perfect. Thanks for the help.
"Rick Rothstein" wrote: I'm not totally clear what your test is supposed to be. Does this do what you want? =AND(COUNTIF(F277:F284,B4)0,B6=0) -- Rick (MVP - Excel) "Randy" wrote in message ... I'm wanting to shade a cell if 2 conditions are true. They problem I am having is that one of the cells uses the VLOOKUP function. I can get the cell to change colors if I specify just one condition. Example: =AND(B4=F277,B6=0). I want a range of cells to be specified. When I try this, the condition doesnt work. Such As: =AND(B4=F277:F284,B6=0). I've even tried: =AND(B4=$F$277:$F$284,B6=0). How can I specify a range of cells in a conditional format? Should I be using an IF statement? |
Thread Tools | |
Display Modes | |
|
|