Conditional Format based on range

Hi,
Is there a formula I can use in CF to change the format of a cell if the
value is within a specified range? For example, if the value in B1 matches a
value in A1:A20 then I want the format to change.

Thanks in advance.
Dave

Hi!

Try this:

Select cell B1
Goto Format>Conditional Formatting
Formula Is: =COUNTIF(A$1:A$20,B1)
Click the Format button
Select the desired style(s)
OK out

Biff

"Dave" <Dave@discussions.microsoft.com> wrote in message
news:0BE3657B-362C-489F-BCAC-FB76359C3956@microsoft.com...
> Hi,
> Is there a formula I can use in CF to change the format of a cell if the
> value is within a specified range? For example, if the value in B1 matches
> a
> value in A1:A20 then I want the format to change.
>
> Thanks in advance.
> Dave

Thanks Biff,
That's much more elegant than the =OR(... function I had in there.

Dave


"Biff" wrote:

> Hi!
>
> Try this:
>
> Select cell B1
> Goto Format>Conditional Formatting
> Formula Is: =COUNTIF(A$1:A$20,B1)
> Click the Format button
> Select the desired style(s)
> OK out
>
> Biff
>
> "Dave" <Dave@discussions.microsoft.com> wrote in message
> news:0BE3657B-362C-489F-BCAC-FB76359C3956@microsoft.com...
> > Hi,
> > Is there a formula I can use in CF to change the format of a cell if the
> > value is within a specified range? For example, if the value in B1 matches
> > a
> > value in A1:A20 then I want the format to change.
> >
> > Thanks in advance.
> > Dave
>
>
>

You're welcome!

Biff

"Dave" <Dave@discussions.microsoft.com> wrote in message
news:D2462703-27CA-41CA-BBE0-CD3DEF756546@microsoft.com...
> Thanks Biff,
> That's much more elegant than the =OR(... function I had in there.
>
> Dave
>
>
> "Biff" wrote:
>
>> Hi!
>>
>> Try this:
>>
>> Select cell B1
>> Goto Format>Conditional Formatting
>> Formula Is: =COUNTIF(A$1:A$20,B1)
>> Click the Format button
>> Select the desired style(s)
>> OK out
>>
>> Biff
>>
>> "Dave" <Dave@discussions.microsoft.com> wrote in message
>> news:0BE3657B-362C-489F-BCAC-FB76359C3956@microsoft.com...
>> > Hi,
>> > Is there a formula I can use in CF to change the format of a cell if
>> > the
>> > value is within a specified range? For example, if the value in B1
>> > matches
>> > a
>> > value in A1:A20 then I want the format to change.
>> >
>> > Thanks in advance.
>> > Dave
>>
>>
>>