How to apply Conditional Formatting in Excel and Python Pandas

In this video, we will once again compare Excel and Python and learn How to apply Conditional Formatting in Excel and Python.

This channel focuses on the mindset and tools you require to excel at your work, be it in the workplace or in your life. We have over 100 videos on Excel and 30 on Power Query. Please check out the playlists.

Do subscribe to the channel. And hit that Bell notification icon.
Please subscribe to my YouTube channel and click the BELL icon to get the tips the moment I post them!
I recommend that you start with my playlists.
I make videos on:

If you like my video(s), encourage me by buying me a coffee:

Image credits: Pixabay.Com

"Copyright Disclaimer Under Section 107 of the Copyright Act 1976, the allowance was made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a copyright law that will otherwise be infringing. Non-profit, educational or personal use"

[mdnurrashedkhan]

It did not work. I can not color cell using Lambda function. Please help

[techdost]

data.style.apply(lambda x: ['background:red' if threshold > 1000 else 'background:green' for x in data.Quantity], axis = 0)

[aishwaryasumbre]

when apply threshold it didn't work in same way
eg. if threshold ="$100"
df.style.apply(lambda x: ['background:yellow' if x <threshold else 'background:green' for x in data.Actual], axis=0)
function highlights values with random .
please tell what to do in this case?