How to apply conditional formatting in Excel using Python | Automate Excel reports | XlsxWriter

In this video we'll cover how to apply conditional formatting in Excel using Python. We will produce well composed, visually appealing Excel reports.
We will cover two methods; first with Pandas and output the DataFrame to Excel. However, there are limited options for customizing the output to make it visually appealing.
In the second method, we will use XlsxWriter module to customize and enhance the Excel workbooks. We will use XlsxWriter apply conditional formatting to an Excel workbook. Also, we will produce a well composed, visually appealing, and practical Excel workbook.

Link to Pandas tips and tricks video:

---------------------------------------------
Follow me on social media!

---------------------------------------------

#conditionalformating #Excel #XlsxWriter

Topics covered in this video:
0:00 - Intro to conditional formatting
0:57 - Import libraries and read data
1:27 - Method 1: Function to highlight rows
2:28 - Save to Excel
3:25 Method 2: XlsxWriter
3:40 - Create Excel workbook and worksheet with XlsxWriter
3:54 - Set zoom, format headers & add title
4:20 - Add Title and Sub-title
4:31 - Format numbers
4:50 - Conditional Formatting
6:02 Export formatted report to Excel

[BiInsightsInc]

Related Videos on this topic covering Excel reporting:

[umersaeed]

Hi Thanks a lot for sharing a very nice videos.
Can You share the video in which we can format MultiIndex header in XLSXwriter.

[nanawallace]

Hello. Thank you for this video. Can you please make a conditional formatting of strings (more than 2 conditions)

[nkankanala]

Thank you for video. How to apply only for a specific column(s) instead of whole row ?

[anshamma.m]

Excel sheet format
3 column 1st column Time 2nd column parameter 1 and 3rd column parameter 2
My conditions is if(parameter 1>20) This conditions true mean print tine row
I neet this logic code

[KurtBonello]

Is it possible to edit an excel in jupyter based on the formatting in the excel?
For example if the cell is white and unlocked, then write a zero in that cell.
Thanks

[_sharma]

Using Python, how to compare millions of records after exporting it in excel from cross database?