title: Excel conditional formatting with blanks and Today()
body: <p>I am trying to get a cell to highlight, given 2 criteria. The cell must be blank, and today's date must be after a predetermined date that is listed in another cell(R8C3). I'm also using R1C1 notation, but understand A1 notation as well.
  The part I don't understand is that each criteria works independently, but when I use the <code>AND</code> function it no longer works. The relative references are used since this formatting will span multiple columns.</p>
  
  <p><code>=ISBLANK(RC)</code> evaluates to true and highlights correctly.</p>
  
  <p><code>=TODAY()&gt;=INDIRECT(ADDRESS(ROW(R8C3),COLUMN(RC)))</code> evaluates to true and highlights appropriately.</p>
  
  <p><code>=AND(ISBLANK(RC),TODAY()&gt;=INDIRECT(ADDRESS(ROW(R8C3),COLUMN(RC))))</code> Does not highlight.</p>
  
  <p>A slightly modified version pasted in a cell ( to check that the formula works) evaluates appropriately to <code>TRUE</code> or <code>FALSE</code>.
  <code>=AND(ISBLANK(RC3),TODAY()&gt;=INDIRECT(ADDRESS(ROW(R8C3),COLUMN(RC3))))</code></p>
  
  <p>I'm using Excel 2010 (version 14) on a Windows 7 device.</p>