title: Two different interior cell color give me the same colorIndex VBA
body: <p>Why two diffrent cells color give me the same ColorIndex ?</p>
  
  <p>I use this function to get the cell color index:</p>
  
  <pre><code>Function InteriorColor(CellColor As Range)
   Application.Volatile
   InteriorColor = CellColor.Interior.ColorIndex
   End Function
  </code></pre>
  
  <p>This is what the function return:</p>
  
  <p><a href="https://i.stack.imgur.com/3zCUk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3zCUk.png" alt="enter image description here"></a></p>