Excel Conditional Formatting using Formulas

Excel Conditional Formatting using Formulas : Learn how to highlight relevant cells with formulas and go beyond the predefined conditions available. Make your excel reports more useful with this feature.
Sign Up for Complete Excel Foundation Course:
Link to Free Excel Mini-Course:

What is covered in this Excel tutorial:
==============
00:00 Introduction
0107 Format a cell using Formula
01:50 Format for writing conditions
05:52 Add multiple conditions for formatting
06:10 Highlight entire row when conditions are met.

#ramgopalexcel

[thecodingboat]

This is the best video I have seen on the internet for conditional formatting, you have solved all the challenges of conditional formatting.

[danielekstrand]

OMG! I have struggled with this for so long. This is by far THE best explanation I have personally seen. Thanks so much. Definitely a new subscriber.

[arayahomes]

I LOVE HOW you explain the why to us. I love how the why is explained in layman terms, great video and amazing instruction. Keep up the layman speak, it's so useful for everyone and not just techies. Awesome. I definitely am subscribing, you really understand how to teach, which is a rare thing.

[bhakti]

whoever is explaining this has very excellent teaching skills. ive seen many videos but this one is most helpful and it solved my problem in least time. i wish i had seen it before, much of my time wudve been saved.

[imrachid]

I just wanted to take a moment to say a huge thank you for your help with my Excel problem. Your video tutorial was incredibly helpful and I was able to follow along step-by-step to fix the issue I was having.

[pv]

Sir .. you are giving out so much more to the world. its really inspiring . your videos are great and next level common sense .

[AshokX]

Awesome way to make things clear... Thanks for the video...

[bhakti]

if you want to save time figuring excel you shud stick to this place its realy excellent

[storiesreadaloudforkids]

thankyou very much for explaining clearly how to use this, I am truly grateful. It saved a lot of time and research

[rikardsred]

Greetings from Brazil :)
Thank you very much for your video! It really helped!
I applied conditional formatting as you taught here based on a reference cell value. In this way, by changing the value in that specific field the color code follows.
So I did 3 formulas:
1.) Go to Conditional Formatting >> New Rule >> Format only cells that contain
... Drop down#1: Cell Value
... Drop down #2: greater than or equals to
... Drop down #3: Clicked on the cell I wanted as reference (ex. =$B$5)
... Format = color green

2.) Then I just replicate the same process for condition 'less than' the cell reference with format yellow color and another condition for when it's 'less than' 0 (Zero) format red color

Works like a charm! And now I have more flexibility in my conditional formatting!

[c.fiouzi]

Took me days to figure out this free range thing! You ARE THE BEST!

[ravikumar-upcz]

Thank you so much for explaining cf with ease

[sauryatomer]

Excellent presentation. Loved the way you explained an important excel functionality in simple and precise manner.

[chrisvale]

Thank you! Very informative and I was able to accomplish what I needed to.

[lorenaabreu]

Beautiful, clear and precise explanation process

[sivakumarcp]

The way you teaching is awesome with basic error handling Technic....

[kaysenayudianto]

Excellent, this is the video i needed thank you so much!

[seherstudios]

Sir ur video is really very informative, plz share more videos of excel im learning it, ur videos will prove to be much helpful for me!!thanks.

[Metztlim]

Thank you so much for sharing this, I was going bananas not knowing what to do here!

[lamacumeca]

New subscriber! Excellent explanation and presentation.