title: Using TODAY() in YYYY-MM-DD format with Conditional Formatting in Excel
body: <p>In Excel, is there a way to format TODAY() into the YYYY-MM-DD format? I've setup Conditional Formatting so that if a cell =TODAY(), the entire row becomes bold. However, it only works when the dates are in standard MM-DD-YYYY format. Any suggestions?</p>
  
  <p>Current Conditional Formatting formula looks like this:</p>
  
  <pre><code>=$B1=TODAY()
  </code></pre>
  
  <p><em>The date cells, which come from an external database are stored as YYYY-MM-DD in column 'B'.</em></p>
  
  <p>Thank you in advance!</p>