title: Conditional formatting(custom format) with multiple conditions for a number in Excel
body: <p>I want to format a number as M(million), B(Billion) or K(thousand) dynamically based on the value in the cell. I tried (but this does not work):</p>
  
  <pre><code>[&gt;1000000000]0,,,"B";[&gt;1000000]0,,"M";[&gt;1000]0,"K";0”
  </code></pre>
  
  <p>If I give any two conditions it works, eg:  </p>
  
  <pre><code>[&gt;1000000000]0,,,"B";[&gt;1000000]0,,"M";0  
  </code></pre>
  
  <p>or  </p>
  
  <pre><code> [&gt;1000000]0,,"M";[&gt;1000]0,"K";0 )
  </code></pre>
  
  <p>Refer : <a href="https://www.sumproduct.com/thought/multiple-number-formatting.html" rel="nofollow">https://www.sumproduct.com/thought/multiple-number-formatting.html</a></p>