Help With Dynamic Range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Big H - 27 Oct 2006 15:24 GMT

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(SearchResults!$I:$I,"CCLS"),12)

Reply to this Message

Teethless mama - 27 Oct 2006 15:44 GMT

Select your range

Conditional Formatting

Formula Is =AND($A1="Actual",SEARCH(*CCLS*,$B1))

Format any color you want

> Hi There,
>
[quoted text clipped - 7 lines]
>
> =OFFSET(SearchResults!$A$2,0,0,COUNTIF(SearchResults!$I:$I,"CCLS"),12)

Reply to this Message

Big H - 27 Oct 2006 16:32 GMT

Hi There,
Its got to be a dynamic range formula as I have name defined, which is used
in a macro.

thanks Harry

> Select your range
>
[quoted text clipped - 17 lines]
>>
>> =OFFSET(SearchResults!$A$2,0,0,COUNTIF(SearchResults!$I:$I,"CCLS"),12)

Reply to this Message