| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help With Dynamic Range
Hi There,
I am not sure if what I want can be done with a Dynamic Range. The formula below works great for capturing anything within the range that is "CCLS", however I now require the formula to look down ColumnA and ColumnI, and anything that matches "Actual" in ColumnA and anything that matches "CCLS" in columnI, highlight this range. tia Harry =OFFSET(SearchResults!$A$2,0,0,COUNTIF(SearchResul ts!$I:$I,"CCLS"),12) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help With Dynamic Range
Select your range
Conditional Formatting Formula Is =AND($A1="Actual",SEARCH(*CCLS*,$B1)) Format any color you want "Big H" wrote: Hi There, I am not sure if what I want can be done with a Dynamic Range. The formula below works great for capturing anything within the range that is "CCLS", however I now require the formula to look down ColumnA and ColumnI, and anything that matches "Actual" in ColumnA and anything that matches "CCLS" in columnI, highlight this range. tia Harry =OFFSET(SearchResults!$A$2,0,0,COUNTIF(SearchResul ts!$I:$I,"CCLS"),12) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help With Dynamic Range
Hi There,
Its got to be a dynamic range formula as I have name defined, which is used in a macro. thanks Harry "Teethless mama" wrote in message ... Select your range Conditional Formatting Formula Is =AND($A1="Actual",SEARCH(*CCLS*,$B1)) Format any color you want "Big H" wrote: Hi There, I am not sure if what I want can be done with a Dynamic Range. The formula below works great for capturing anything within the range that is "CCLS", however I now require the formula to look down ColumnA and ColumnI, and anything that matches "Actual" in ColumnA and anything that matches "CCLS" in columnI, highlight this range. tia Harry =OFFSET(SearchResults!$A$2,0,0,COUNTIF(SearchResul ts!$I:$I,"CCLS"),12) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WEEKNUM to dynamic range name | Excel Worksheet Functions | |||
| Can't chart dynamic named range?? | Charts and Charting in Excel | |||
| Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
Linear Mode
