Conditional Format

[lehigh]

Hi All

I have one letter in A3

I have 20 letters in C3. All seperated by a comma and a space

I would like to "Conditional Format" A3 to color the cell if the
letter in A3 can match one of the 20 letters in C3.

Can anyone help me with this?

Thanks very much for the help

Tom Snyder

 

[Felipe]

Tom,

With A3 selected go to Format>Conditional formatting
From the pull down list select 'Formula is'
Type: =ISNUMBER(FIND($A$3,$C$3))
Select the apropriate format and click OK.

If you want to paste this formatting to other cells or
apply it to a range, check if cell references have to be
absolute or relative (i.e. remove or add '$' as needed)

Regards,
Felipe