Conditional formatting if value in cell is found in a named range

[Grumpy Grandpa]

Hi,

I suppose this should be easy; but, I have searched and searched and
can't find an answer in this group or anywhere else, so here goes:

I need to know what formula to use in my conditional formatting for a
cell such that if I find the exact text that is in the cell in a named
range, then the conditional formatting will apply.

EXAMPLE:

I have a named range, "FNAMES" (D1:F3) that contains first names as
follows:
D E F
1 Billy Marie Kelly
2 Chuck Marty Krissy
3 Artie Percy Harry


Let's say cell A1 contains the text "Krissy"

What formula would I use in the CF box for cell A1 so that it bolds
with a red background? (I don't need help with the formatting part,
just the formula).

Thanks in advance!

[Ken Johnson]

Hi Grumpy Grandpa,

I used =OR($A$1=$D$1:$F$3) and it seems to work.

Ken Johnson

[Ron Coderre]

Try something like this:

for a name in A1

Select A1
<Format><Conditional Formatting>
Formula is: =COUNTIF(FNAMES,A1)
Click the [Format] button...set your format
Click the [OK] buttons
Done

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Grumpy Grandpa" wrote:

> Hi,
>
> I suppose this should be easy; but, I have searched and searched and
> can't find an answer in this group or anywhere else, so here goes:
>
> I need to know what formula to use in my conditional formatting for a
> cell such that if I find the exact text that is in the cell in a named
> range, then the conditional formatting will apply.
>
> EXAMPLE:
>
> I have a named range, "FNAMES" (D1:F3) that contains first names as
> follows:
> D E F
> 1 Billy Marie Kelly
> 2 Chuck Marty Krissy
> 3 Artie Percy Harry
>
>
> Let's say cell A1 contains the text "Krissy"
>
> What formula would I use in the CF box for cell A1 so that it bolds
> with a red background? (I don't need help with the formatting part,
> just the formula).
>
> Thanks in advance!
>
>

[Ken Johnson]

Hi Grumpy Grandpa,

=OR($A$1=FNAMES) also seems to work OK.

Ken Johnson

[Ashish Mathur]

Hi,

In conditional formatting, do the following:

"Cell value is" "equal to" "name" (w/o the quotes)

Regards,

Ashish Mathur

"Grumpy Grandpa" wrote:

> Hi,
>
> I suppose this should be easy; but, I have searched and searched and
> can't find an answer in this group or anywhere else, so here goes:
>
> I need to know what formula to use in my conditional formatting for a
> cell such that if I find the exact text that is in the cell in a named
> range, then the conditional formatting will apply.
>
> EXAMPLE:
>
> I have a named range, "FNAMES" (D1:F3) that contains first names as
> follows:
> D E F
> 1 Billy Marie Kelly
> 2 Chuck Marty Krissy
> 3 Artie Percy Harry
>
>
> Let's say cell A1 contains the text "Krissy"
>
> What formula would I use in the CF box for cell A1 so that it bolds
> with a red background? (I don't need help with the formatting part,
> just the formula).
>
> Thanks in advance!
>
>

[Grumpy Grandpa]

Thanks. Works great!