title: Excel conditional formatting using generic formula
body: <p>I want to conditionally format cells in Excel. Is it possible to create a generic formula that does the following:</p>
  
  <pre>
      IF the value in column A of the given row = "A" 
      AND the value in the given cell is greater than .1 
      AND the value in the given cell is less than 1
      THEN format the cell with a light grey background color
  </pre>
  
  <p>In the example below, I want the formula to apply to cells B1:K2, but I only want cells E1, I1 and K1 to be highlighted in grey.</p>
  
  <p><img src="https://i.stack.imgur.com/EKlxA.png" alt="enter image description here"></p>