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
>>
>>
>>