title: Google sheets - conditional formatting from other sheet
body: <p>I have two spreadsheets (S1 and S2). I want to apply conditional formatting to column D from S1 such that:</p>
  
  <ul>
  <li>if text from cell D1, D2,... from S1 is present in column A from S2, a cell is colored green</li>
  <li>if text from cell D1, D2,... from S1 is not present in column A from S2, a cell is colored red</li>
  </ul>
  
  <p>Could not get my mind around it, could you please help? I assume I must use a formula, but not sure how...</p>