title: Excel Conditional formatting from one to many
body: <p>There are 3 sheets in my workbook
  A! Squad Names and base details</p>
  <h1>[ Squad # | Engaged (YES|NO) | Squad Name | Base |  ]</h1>
  <p>Squad Name is highlighted when they are Engaged</p>
  <p>B! Squad Mission(s)</p>
  <h1>[ MOS # | Squad | MOS Name | MOS Desc |  ]</h1>
  <p>C! Required Data-Validation Lists for ease in Search of A!</p>
  <p>I understand how to conditionally format of column C when column B has a specific value.
  I want to Highlight the MOS Name(s) on page B! associated with specific squad names when the squad is marked as Engaged on A!.
  Squad names are associated with from 5 to 17 MOS codes.</p>