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 FormatConditional Formatting
Formula Is: =COUNTIF(A$1:A$20,B1)
Click the Format button
Select the desired style(s)
OK out

Biff

"Dave" wrote in message
...
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 FormatConditional Formatting
Formula Is: =COUNTIF(A$1:A$20,B1)
Click the Format button
Select the desired style(s)
OK out

Biff

"Dave" wrote in message
...
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" wrote in message
...
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 FormatConditional Formatting
Formula Is: =COUNTIF(A$1:A$20,B1)
Click the Format button
Select the desired style(s)
OK out

Biff

"Dave" wrote in message
...
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