Openpyxl - Color Scale Conditional Formatting in Excel Workbooks with Python | Data Automation

This video demonstrates how to apply a green-to-red color scale rule to a column of data in an excel workbooks using Python's library Openpyxl. I use Anaconda's Jupyter Lab interface.

😄 Please consider supporting this channel and making this content possible:

00:00 :: Intro and Workbook review
00:50 :: Importing and creating the ColorScaleRule object
02:20 :: Adding the object to the worksheet
03:17 :: Overview

#PythonExcelTutorial #openpyxl #DataAutomation #python #pythontutorial #excel #pythonautomation #pythonprogramming #data #jupyterlab