How do I conditional format excel based on cell value using PSSE excelpy?

asked 2020-09-12 10:24:18 -0500

DanSmith gravatar image

Hello Friends, I would like to know how do I format an excel cell based on cell value?

Example: say cell A1 has value of 70. I wanted to set the background color of the cell to GREEN if the value is less than 85 and YELLOW if the value is between 85 and 95 and RED if the value is over 95.

I'm new to PSSE python and couldn't find any method in PSSE API document that does the above.

Please help and thanks in advance.

edit retag flag offensive close merge delete