title: Excel 2010 - Conditional Formatting Multiple Cells
body: <p>I'm using Excel 2010 on Windows 7</p>
  
  <p>I have a drop down in column A (options to select are open and closed) and when I select the option of closed then i would like ONLY specific cells within that row to be 'greyed out'. </p>
  
  <p>Unfortunately I only know a formula to format a whole row <code>(=INDIRECT("A"&amp;ROW())="Closed")</code> but this does not work for me as i only require specific cells to be greyed out and not the whole row</p>
  
  <p>Please advise of the correct formula which i can apply to the whole spreadsheet.</p>
  
  <p>Cell which contains the drop down options of open, closed: A6
  Corresponding cells within that row which require formatting: <code>B6 D6 E6 G6 I6 J6 K6 M6 N6</code></p>