Match Cells

N

nycard64

Board Regular
Joined
Dec 23, 2009
Messages
113
I am trying to match up Metals from C to E & H and if there is one missing to highlight the cell some how. I have some Tool-Ch with only a few in the list and some have all. See attached sheets for two different cases. Any suggestions if this can be done?


Sheet2

<table style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 65px"> <col style="WIDTH: 55px"> <col style="WIDTH: 74px"> <col style="WIDTH: 94px"> <col style="WIDTH: 74px"> <col style="WIDTH: 14px"> <col style="WIDTH: 45px"> <col style="WIDTH: 78px"> <col style="WIDTH: 14px"></colgroup> <tbody> <tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"> <td> </td> <td>A</td> <td>B</td> <td>C</td> <td>D</td> <td>E</td> <td>F</td> <td>G</td> <td>H</td> <td>I</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</td> <td style="FONT-SIZE: 10pt">Tool-Ch</td> <td style="FONT-SIZE: 10pt">Metal</td> <td style="FONT-SIZE: 10pt">Mea Tool</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">TXRF Metals</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">VDPAA Metal</td> <td style="FONT-SIZE: 10pt"> </td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</td> <td style="FONT-SIZE: 10pt">JB01-C</td> <td style="FONT-SIZE: 10pt">Al</td> <td style="FONT-SIZE: 10pt">VDPAA</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">Ca</td> <td style="TEXT-ALIGN: right; FONT-SIZE: 10pt">1</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">Al</td> <td style="TEXT-ALIGN: right; FONT-SIZE: 10pt">1</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</td> <td style="FONT-SIZE: 10pt">JB01-C</td> <td style="FONT-SIZE: 10pt">Co</td> <td style="FONT-SIZE: 10pt">TXRF</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">Co</td> <td style="TEXT-ALIGN: right; FONT-SIZE: 10pt">1</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">Na</td> <td style="TEXT-ALIGN: right; FONT-SIZE: 10pt">1</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</td> <td style="FONT-SIZE: 10pt">JB01-C</td> <td style="FONT-SIZE: 10pt">Cr</td> <td style="FONT-SIZE: 10pt">TXRF</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">Cr</td> <td style="TEXT-ALIGN: right; FONT-SIZE: 10pt">1</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</td> <td style="FONT-SIZE: 10pt">JB01-C</td> <td style="FONT-SIZE: 10pt">Cu</td> <td style="FONT-SIZE: 10pt">TXRF</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">Cu</td> <td style="TEXT-ALIGN: right; FONT-SIZE: 10pt">1</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</td> <td style="FONT-SIZE: 10pt">JB01-C</td> <td style="FONT-SIZE: 10pt">Fe</td> <td style="FONT-SIZE: 10pt">TXRF</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">Fe</td> <td style="TEXT-ALIGN: right; FONT-SIZE: 10pt">1</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</td> <td style="FONT-SIZE: 10pt">JB01-C</td> <td style="FONT-SIZE: 10pt">Hf</td> <td style="FONT-SIZE: 10pt">TXRF</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">Hf</td> <td style="TEXT-ALIGN: right; FONT-SIZE: 10pt">1</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</td> <td style="FONT-SIZE: 10pt">JB01-C</td> <td style="FONT-SIZE: 10pt">K </td> <td style="FONT-SIZE: 10pt">TXRF</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">K</td> <td style="TEXT-ALIGN: right; FONT-SIZE: 10pt">1</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</td> <td style="FONT-SIZE: 10pt">JB01-C</td> <td style="FONT-SIZE: 10pt">La</td> <td style="FONT-SIZE: 10pt">TXRF</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">La</td> <td style="TEXT-ALIGN: right; FONT-SIZE: 10pt">1</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td></tr> <tr style="HEIGHT: 18px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</td> <td style="FONT-SIZE: 10pt">JB01-C</td> <td style="FONT-SIZE: 10pt">Na</td> <td style="FONT-SIZE: 10pt">VDPAA</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">Mn</td> <td style="TEXT-ALIGN: right; FONT-SIZE: 10pt">1</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</td> <td style="FONT-SIZE: 10pt">JB01-C</td> <td style="FONT-SIZE: 10pt">Ni</td> <td style="FONT-SIZE: 10pt">TXRF</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">Ni</td> <td style="TEXT-ALIGN: right; FONT-SIZE: 10pt">1</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</td> <td style="FONT-SIZE: 10pt">JB01-C</td> <td style="FONT-SIZE: 10pt">Ta</td> <td style="FONT-SIZE: 10pt">TXRF</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">Pt</td> <td style="TEXT-ALIGN: right; FONT-SIZE: 10pt">1</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</td> <td style="FONT-SIZE: 10pt">JB01-C</td> <td style="FONT-SIZE: 10pt">Ti</td> <td style="FONT-SIZE: 10pt">TXRF</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">Ta</td> <td style="TEXT-ALIGN: right; FONT-SIZE: 10pt">1</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</td> <td style="FONT-SIZE: 10pt">JB01-C</td> <td style="FONT-SIZE: 10pt">W </td> <td style="FONT-SIZE: 10pt">TXRF</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">Ti</td> <td style="TEXT-ALIGN: right; FONT-SIZE: 10pt">1</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</td> <td style="FONT-SIZE: 10pt">JI01-4</td> <td style="FONT-SIZE: 10pt">Co</td> <td style="FONT-SIZE: 10pt">TXRF</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">W</td> <td style="TEXT-ALIGN: right; FONT-SIZE: 10pt">1</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</td> <td style="FONT-SIZE: 10pt">JI01-4</td> <td style="FONT-SIZE: 10pt">Cr</td> <td style="FONT-SIZE: 10pt">TXRF</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt">Zn</td> <td style="TEXT-ALIGN: right; FONT-SIZE: 10pt">1</td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td> <td style="FONT-SIZE: 10pt"> </td></tr></tbody></table>

Excel tables to the web >> Excel Jeanie HTML 4


Sheet2

<table style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 65px"> <col style="WIDTH: 55px"> <col style="WIDTH: 74px"></colgroup> <tbody> <tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"> <td> </td> <td>A</td> <td>B</td> <td>C</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">273</td> <td style="FONT-SIZE: 10pt">JQ01-A</td> <td style="FONT-SIZE: 10pt">Al</td> <td style="FONT-SIZE: 10pt">VDPAA</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">274</td> <td style="FONT-SIZE: 10pt">JQ01-A</td> <td style="FONT-SIZE: 10pt">Co</td> <td style="FONT-SIZE: 10pt">TXRF</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">275</td> <td style="FONT-SIZE: 10pt">JQ01-A</td> <td style="FONT-SIZE: 10pt">Cr</td> <td style="FONT-SIZE: 10pt">TXRF</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">276</td> <td style="FONT-SIZE: 10pt">JQ01-A</td> <td style="FONT-SIZE: 10pt">Cu</td> <td style="FONT-SIZE: 10pt">TXRF</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">277</td> <td style="FONT-SIZE: 10pt">JQ01-A</td> <td style="FONT-SIZE: 10pt">Fe</td> <td style="FONT-SIZE: 10pt">TXRF</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">278</td> <td style="FONT-SIZE: 10pt">JQ01-A</td> <td style="FONT-SIZE: 10pt">Hf</td> <td style="FONT-SIZE: 10pt">TXRF</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">279</td> <td style="FONT-SIZE: 10pt">JQ01-A</td> <td style="FONT-SIZE: 10pt">K </td> <td style="FONT-SIZE: 10pt">TXRF</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">280</td> <td style="FONT-SIZE: 10pt">JQ01-A</td> <td style="FONT-SIZE: 10pt">La</td> <td style="FONT-SIZE: 10pt">TXRF</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">281</td> <td style="FONT-SIZE: 10pt">JQ01-A</td> <td style="FONT-SIZE: 10pt">Na</td> <td style="FONT-SIZE: 10pt">VDPAA</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">282</td> <td style="FONT-SIZE: 10pt">JQ01-A</td> <td style="FONT-SIZE: 10pt">Ni</td> <td style="FONT-SIZE: 10pt">TXRF</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">283</td> <td style="FONT-SIZE: 10pt">JQ01-A</td> <td style="FONT-SIZE: 10pt">Ta</td> <td style="FONT-SIZE: 10pt">TXRF</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">284</td> <td style="FONT-SIZE: 10pt">JQ01-A</td> <td style="FONT-SIZE: 10pt">Ti</td> <td style="FONT-SIZE: 10pt">TXRF</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">285</td> <td style="FONT-SIZE: 10pt">JQ01-A</td> <td style="FONT-SIZE: 10pt">W </td> <td style="FONT-SIZE: 10pt">TXRF</td></tr></tbody></table>

Excel tables to the web >> Excel Jeanie HTML 4
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
You must log in or register to reply here.

Similar threads

E
  • Question Question
VBA code clean up
Replies
9
Views
581
mumps
mumps
R
  • Question Question
import specific columns from one workbook to another from matching header with vba
Replies
1
Views
135
Peter_SSs
Peter_SSs
D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
622
smozgur
smozgur
C
  • Question Question
Picture won't paste in cell overlay
Replies
0
Views
249
Cerka
C
E
  • Question Question
Adding a custom message.
Replies
1
Views
663
Micron
M

Forum statistics

Threads
1,224,583
Messages
6,179,672
Members
452,937
Latest member
Bhg1984

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top