title: Conditional formatting based on multiple cells
body: <p>I'm trying to make a formula for the following, and can't figure out how to get all the conditions in there:</p>
  
  <p>**Column A will be highlighted if:</p>
  
  <p>G# is blank </p>
  
  <p>AND/OR</p>
  
  <p>H is today or before, WHEN J is blank**</p>
  
  <p>to better illustrate, 
  A is the client's name / 
  G is date term's contract was signed /
  H is date of next contract /
  J is date contract on H was signed</p>
  
  <p>I'm trying to get the client's name highlighted when the contract is due for signature, so if G is blank it should be highlighted, and if H is due and J is blank it should be highlighted.</p>
  
  <p>And I would like to have this formula in the range A1:A137, with the G,H and J changing accordingly for each row.</p>