Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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

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.