Home |
Search |
Today's Posts |
#1
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |