Excel Conditional Formatting (Overview + Advanced Examples)

In this video, you will learn all about conditional formatting in Excel.

The video covers the following topics:
-- Introduction to Conditional Formatting
-- Using Formula in Conditional Formatting
-- Advanced Examples (Highlight Every Nth Row, Creating Dynamic Search)

Conditional formatting is a great feature in Excel that allows you to highlight data points based on the specified conditions. It's loaded with features and you can use it to apply a background color to a cell based on the value in it.

You can also change a lot of formatting (such as font type, font size, border, etc.) with conditional formatting.

Apart from it, conditional formatting has a rich set of icons that you can use to make your data more visual. For example, you can use it to apply tick mark and cross mark or traffic lights icons based on the cell value.

One of the most powerful aspects of conditional formatting is that you can use a custom formula to check cell value and apply formatting to it accordingly.

For example, if you want to highlight all the rows where the sales value is less than 100, you can do this by using a custom formula in conditional formatting.

There are many awesome things you can do with conditional formatting in Excel and this video covers a few examples of that. I will show you how to highlight every other rows in Excel using conditional formatting and how to create a dynamic search in Excel using conditional formatting.

This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[surjagain]

Superb tutorial, very nicely done and extremely helpful!

[priyankasaha]

No comparison of these videos. Thank you so much

[sucmitra]

You should have got more than 15k likes.. Its a wonderful training, thanks a lot

[stevelco]

I was looking for the way to conditionally format a range of cells. Your video covers it succinctly and nicely at around the 9:50 mark. Thank you so much!

[shivashankar]

This is one of the top most formula about Conditional formatting in excel.hete I have learned many things.thank you very much.

[benrabahmohamed]

Thanks a lot well explained
From algeria

[wayneedmondson]

Hi Sumit.. great tips and tricks. I especially like the Dynamic Search trick using the Text Box (ActiveX Control).. very clever and useful. Thanks for sharing this video series. Thumbs up!

[el_benny_]

you explained dynamic conditional formatting very well. thank you

[iliesboukhatem]

a very useful tutorial, thank you so much

[ahmed.elhassan]

that's very good
many thanks for

[sudeepsaha]

18:06 Instead of making the formula Complex, couldn't we use this [ =$F$1=$B3 ] formula in Custom Formatting? Just only drawback is we can't use the TextBox from the Developer Tab. But there is another cool way I just want share.

Use a Helper Column> Copy All the Names > use 'Remove Duplicates' option from Data tab to get a List of Unique Names > Use this list and create a Drop-down list on Cell F1 by using Data Validation. 😄

[KhadimHussain-xesw]

Keep going sir
You are doing very awesome and flamboyant work sir

[Abhijit]

sir I didn't get the exact pdf of this lecture in your pdf file

[zeeshanshaikh]

Too good sir but plz provide practice sheet link as u have provided in ur custom formatting video here ur given the link of ur website but after opening it i am not understand how to download it

[syedzama]

Same like if we have 2 year product life it should remove before 2 month before same 3 years 90 days before remove so how we make a excel sheet and formula to monitor it

[hafizurrahman]

Nice
Sir I want to know the shortcut key of subtotal function above of column.

[rishikesh]

In this example If I want to highlight all rows having name as "Bob", "Harry" and "Mark". Which formula should I use?

[syedzama]

Dear Sir,
If we have production and expiery date of product and we have certain rules also like 1 year life product remove date 1 month before expiry date

[deborahmitchell]

can you go over a due date? Ex on Jan 1 2021 15 days later an event is due

[paranchidu]

Hi sir I have some doubts on Excel probelms sir wil u help me sir