Conditional Format

  • Thread starter Thread starter lehigh
  • Start date Start date
L

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
 
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
 
Back
Top