![]() |
#1
|
|||
|
|||
![]()
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 |
Tags |
cell color, if then, what if |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
VBA Word - Find Specific Table - Prepend & Append Data to Each Cell | jc491 | Word VBA | 3 | 12-02-2015 09:48 PM |
![]() |
jc491 | Word VBA | 8 | 09-30-2015 06:10 AM |
![]() |
canar | Word Tables | 3 | 09-08-2015 03:36 PM |
![]() |
epsulliv | Word Tables | 6 | 08-24-2015 07:29 AM |
find 2 values i a table to find the right prise | Vibov | Excel | 1 | 01-11-2015 07:25 AM |