Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-07-2017, 03:53 PM
curbsidejimmy curbsidejimmy is offline Quetion if then to find data in a table Windows 7 64bit Quetion if then to find data in a table Office 2007
Novice
Quetion if then to find data in a table
 
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
 

Tags
cell color, if then, what if



Similar Threads
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
Quetion if then to find data in a table VBA Table – Search All Tables - Find & Replace Text in Table Cell With Specific Background Color jc491 Word VBA 8 09-30-2015 06:10 AM
Quetion if then to find data in a table use existing table data and not get generic excel chart data canar Word Tables 3 09-08-2015 03:36 PM
Quetion if then to find data in a table Importing Data from Excel - Format of table messed up in Word Table 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:23 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft