'compare two columns and color greater in excel using python?

I came across conditional formatting https://xlsxwriter.readthedocs.io/working_with_conditional_formats.html But not sure how to implement it. I have my result saved in dataframe, i am trying to do this color formatting based on if column2> column1: color column2 else: do nothing and save the excel file. any suggestions.

Solution 1:^[1]

   worksheet.conditional_format('B1:B9' ,
                         {'type':'formula',
                          'criteria': '=AND($A1<$B1,$B1>0)',
                          'format':   format1})

Solution 2:^[2]

transform = CATransform3DScale(transform, 0, 0, 1) should be increased from 1. It was a mistake on my part and not understanding what the transform was supposed to do

Also from value should not be identity

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1
Solution 2

'compare two columns and color greater in excel using python?

Solution 1:[1]

Solution 2:[2]

Sources

Related Questions

Solution 1:^[1]

Solution 2:^[2]