Currently I save my dataframe like this
writer = ExcelWriter('test.xlsx')
test_df.to_excel(writer,'Sheet1')
writer.save()
And resulted excel file looks like this
cus 1 abc 2 jbd 3 lkl ...
1 col v v v v v ...
2 v v col v v v ...
3 v v v v col v ...
What I need is that, when cus value == header value, that cell should have a green background. In example above, all cells with value 'col' should be set green background. How can I do this?