title: Insert text in cells when above cell meets condition
body: <p>I have a schedule sheet for the whole year for a group.
  The third row has all the dates of the year, the next couple of rows has the name of each group member. </p>
  
  <p>Members specified in A4:A9.
  Holidays are specified in cells A20:A28.</p>
  
  <p>So, what I want to do, probably through VBA, is to make a rule like with conditional formatting, that inserts the word "Holiday" in B4:B9 if B3 matches a date in A$20:A$28, and then into C4:C9 if C3 matches and so on.</p>
  
  <p>Now I cannot write this condition in every cell since it's a schedule used by every member, which is the suggestion I often got from googling, and I can't do it with conditional formatting, so I'm guessing VBA is the way to go, but the VBA code I've found so far seems to use specific cells and wouldn't go through each column.</p>