title: Excel Conditional Formatting: If TableColumn = value1 AND ValueFromSameRowButAnotherColumn = value2
body: <p><strong>Context:</strong></p>
  
  <p>I'm working off of a template calendar that autofills a calendar if events and times are listed in a table in another tab.</p>
  
  <p>From that table,
  I've named the date column: <strong>Dates</strong>;
  I've named the event column: <strong>Event</strong></p>
  
  <p>In the calendar, each date has 4 rows 1 column with the date in the first column (e.g. Row B).</p>
  
  <p><strong>Problem:</strong></p>
  
  <p>On the calendar, I want to <strong>conditionally format</strong> so that if the STAT holiday date si listed in the events table, then the 4 rows in the date is shaded grey.</p>
  
  <p>I tried the following formulas but none of them work: =(IF then conditional format)</p>
  
  <ul>
  <li>=AND((Event="STAT"),(Dates=A$8))</li>
  <li>=(Event="STAT")*(Dates=B$4) --> Another question said the * worked the same as AND for conditional formatting</li>
  </ul>
  
  <p>Basically, if the value in the 'Date Column' is the date in the calendar grid, AND if the Event, in the same row as the date referenced in the 'Date Column', is "STAT", then shade the cell grey.</p>
  
  <p>Hope it was all clear, <strong>thank you</strong> in advance :)</p>