software

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, quot;FNAMESquot; (D1:F3) that contains first names as
follows:
D E F
1 Billy Marie Kelly
2 Chuck Marty Krissy
3 Artie Percy HarryLet's say cell A1 contains the text quot;Krissyquot;

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!Hi Grumpy Grandpa,

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

Ken JohnsonTry something like this:

for a name in A1

Select A1
lt;Formatgt;lt;Conditional Formattinggt;
Formula is: =COUNTIF(FNAMES,A1)
Click the [Format] button...set your format
Click the [OK] buttons
Done

Does that help?

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

XL2002, WinXP-Proquot;Grumpy Grandpaquot; wrote:

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

Hi Grumpy Grandpa,

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

Ken JohnsonHi,

In conditional formatting, do the following:

quot;Cell value isquot; quot;equal toquot; quot;namequot; (w/o the quotes)

Regards,

Ashish Mathur

quot;Grumpy Grandpaquot; wrote:

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

Thanks. Works great!