title: openpyxl color cells based on value from another column
body: <pre><code>import pandas as pd 
  from openpyxl import Workbook 
  from pandas import ExcelWriter import openpyxl
  
  wb = Workbook() 
  sheet = wb.active 
  writer = ExcelWriter('path\\test.xlsx')
  
  list1 = [1,1,1,2,3,3,4,5]
  list2 = [1,2,2,2,3,4,4,5]
  
  comparison = [i == j for i,j in zip(list1,list2)]
  comparison Out[76]: [True, False, False, True, True, False, True, True]
  
  df = pd.DataFrame(list1,list2)
  
  dataframe_spotovi.to_excel(writer,'Jazler spotovi') 
  writer.save()
  </code></pre>
  
  <p>I would like to color rows in my 1st column based on their value - all the same values in one color (1,1,1 in red, then 2 in separate color, 3,3 in some other color, 4 in another color etc.).
  I made the list2, so i can check if rows in list1 have same values (comparison).</p>
  
  <p>I tried something like this:</p>
  
  <pre><code>for rows in sheet.iter_rows():
      for cell in rows:
          for a, b in zip(mirko, darko):
              if a == b:
                  cell.fill = PatternFill(bgColor="FFC7CE", fill_type = "solid")
      else:
          color = 'FFBB00'
  </code></pre>
  
  <p>Nothing. I tried dataframe styler, but styler cannot iterate. </p>
  
  <p>Any thoughts? Much appreciated.</p>