title: Read the color of a Excel Cell & change the tab color of that sheet with the same color
body: <p>I would like help with a code for reading the color of an Excel Cell (whose color changes on conditional statement: ) &amp; change the tab color of that sheet based on that cell color. Any help/Suggestion appreciated. Thanks. 
  Here is the conditional statement used in cell:</p>
  
  <pre><code> =WENN(ODER(B2="open";B71="open";B82="open";B107="open");"open";"ok")
  </code></pre>
  
  <p>Here is the code I am using ( I just got some codes online) :</p>
  
  <pre><code>Sub GetRGBColor_Fill()
  'PURPOSE: Change the Tab Color based on the ActiveCell's Fill Color
      If ActiveCell.Interior.Color = RGB(256, 0, 0) Then
          ActiveSheet.Tab.Color = 256
      ElseIf ActiveCell.Interior.Color = RGB(0, 256, 0) Then
          ActiveSheet.Tab.Color = 3
      Else
          'just some random color
          ActiveSheet.Tab.Color = 100
      End If
  </code></pre>
  
  <h2>    End Sub</h2>
  
  <p>My intention is that on the first sheet and on 2 other sheets (among 10 sheets), the color of the respective Tab reflects the color of a particular cell, whose color is based on conditional statements, in the respective sheets. Meaning each of the 3 sheets, would have their own colors based on a cell color in the respective sheet. 
  I know there are errors in the code, I just want some one to point out what is wrong and how I need to correct it. I am new at this, and thus would appreciate any help.</p>