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 - [ Ссылка ]
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: [ Ссылка ]
You can also access the Full Excel Training on YouTube here: [ Ссылка ]
Free Excel Course - [ Ссылка ]
Paid Online Training - [ Ссылка ]
Best Excel Books: [ Ссылка ]
⚙️ Gear I Recommend:
Camera - [ Ссылка ]
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - [ Ссылка ]
Wireless Mic: [ Ссылка ]
Lighting - [ Ссылка ]
Subscribe to get awesome Excel Tips every week: [ Ссылка ]
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
![](https://s2.save4k.ru/pic/WLgkCCi7H8c/maxresdefault.jpg)