title: Google Sheets Conditional formatting custom formula: if current cell is empty, but other cell is not
body: <p>So I'm trying to write a custom formula in google sheets for this condition. I want the current cell to be blacked out if it's empty, but only if this other cell is not empty. This prevents a lot of other cells from being blacked out further down the column (I'm adding new rows periodically as new data becomes available).</p>
  
  <p>I can do something like =E:E&lt;>"", which tests if the other cell is not empty, but I can't figure out how to add to it to test that the current cell is empty.</p>
  
  <p>I want to test that column F is empty, and that column E is not. The row number would be the same, ie F1 is empty, E1 is not empty.</p>
  
  <p>Thanks.</p>