Excel Conditional Formatting (Overview + Advanced Examples)
71.8 هزار بار بازدید -
5 سال پیش
-
In this video, you will
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.
☕ If you're the videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
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.
You can find more details about this Free Excel Training + the download files here: https://trumpexcel.com/learn-excel/
You can also access the Full Excel Training on YouTube here: Getting Started with Excel | Excel Fo...
Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
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.
☕ If you're the videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
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.
You can find more details about this Free Excel Training + the download files here: https://trumpexcel.com/learn-excel/
You can also access the Full Excel Training on YouTube here: Getting Started with Excel | Excel Fo...
Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
5 سال پیش
در تاریخ 1398/02/31 منتشر شده
است.
71,805
بـار بازدید شده