Python Excel automation Part 2 - add formula and conditional formatting

This tutorial explains how to add formula and conditional formatting in excel using python with openpyxl package.
Formula used in this tutorial:
sum, average, round, sumif, countif, concatenate, merge cells

Link for Python Excel Automation-part 3

Link for Python Excel Automation-Read and write in Excel

Link for Build your first mobile app in Python

Link for How to build a Quiz app with Python Tkinter

Link for Display MySQL data in python table :Treeview with horizontal scrollbar

Link for how to connect python with MySQL

Link for text to speech conversion using python
For more python videos:

For cryptography related videos:

Subscribe for more new videos:

Thanks for your support,
#Trinitysoftware

#pythonexcel #pythonexcelautomation

[shreenaths]

Awesome video....
Here i have one doubt, want to apply complex formula inside excel sheet, there is multiple xlsheet. How i apply? Using python

[jcnvlju]

Super madam. You helped me in a very hard work assignment.

[YehLoh]

Madam, do the same without closing Excel workbook please

[niharikaVerma-ijlw]

Hi Ma'am,
I have used formula
Sh['AQ{}'=format(r)]= '=XLOOKUP(L{}, Sheet1!S:S, Sheet1!S:S)'.format(r)
As formula and #NAME? In the frontend. Please Assist what can be done to avoid '@' in excel

[maduraimuhil]

GOOD EFFORT .ALL the BEST. Keep it up. 👏👍🤝

[arisdennard]

Would have been nice to have a link to the Excel files you were using

[rachitajain]

Can we do conditional formatting by comparing a data to another column's data in the same sheet?

[immanuelsuleiman]

Why are you riding inside the console. Just write a script