Color Excel Cell Texts Based on their Values using Python | Openpyxl Tutorial

In this video I demonstrate how you can color the cell text of an Excel spreadsheet based on the cell value using python and the openpyxl library. For this purpose I will choose a column, read the values and color the cell texts according to their values. Two examples are included: string values and numeric values. Enjoy the video and have fun trying it out!

Timestamps:
00:00 Intro
00:20 Open Excel workbook
00:45 Get column index
01:39 Example 1: Color cell texts with string values
04:26 Example 2: Color cell texts with numeric values
06:04 Outro