|
| 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
April 14th, 2009, 02:34 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
April 14th, 2009, 03:13 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
April 14th, 2009, 03:19 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
April 14th, 2009, 03:41 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
April 14th, 2009, 03:51 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | |
|
|
Linear Mode
