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!