title: Highlight a cell if a corresponding cell (in another sheet) has a value in it
body: <p>I am trying to compare pages of employee hours verses sales.  In order to catch myself if I record sales and not hours, I'd like the hours cell for a given date to highlight itself, if the sales cell has a value.  </p>
  
  <p>Here's an example of the "hours" sheet:</p>
  
  <pre>                2-Nov   3-Nov   4-Nov
  Smith   Judy    0.8     7.25    0</pre>
  
  <p>And an example of the "totals" sheet:</p>
  
  <pre>               2-Nov     3-Nov   4-Nov
  Smith   Judy   $15.72    $76.55  $82.13</pre>
  
  <p>The problem would be that Judy is listed as selling $82.13 (E2) in product, while having worked 0 hours (E2) according to the "hours" sheet.  </p>
  
  <p>Is there a conditional formatting formula that I can use to get Excel to highlight the "0" listed under 4-Nov on "Hours"?</p>