View Single Post
 
Old 01-07-2017, 03:53 PM
curbsidejimmy curbsidejimmy is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Jan 2017
Posts: 1
curbsidejimmy is on a distinguished road
Default Quetion if then to find data in a table

a b d c a
a f g e a
c g b f c

I will have a table with many letters in it like the one above but with more letters in it.

I need a way to type in a letter. If the letter matches one or more cells, I need to highlight each cell that contains the letter.

If the letter I type in is a, all of the cells that contain the letter a would turn a certain color, like red or blue.
In some of the cells, there might be one or more letters separated by a comma. The sell would light up if the letter a for example was anywhere in the cell. For example,
If a cell contained just a, it would highlight. If it contained (a,b,c) it would highlight.

What the table represents is the neck of a pedal steel guitar. The excel formula is to find every fret where a certain note occurs. I included that to give an idea of what I am trying to accomplish.

Thanks

Jimmy
Reply With Quote