Conditional Formatting in Excel is using to highlight the color of the cells depending upon the cell's value or user conditions. In normal formatting, we just apply the formatting without any condition or criteria.but while applying conditional formatting in excel you should have some conditions or criteria for the cell value.based on that cell you can apply multiple types of conditional formatting in excel.
In below give an example I have some numbers and i want to HighLight some numbers based on some criteria. let's see those numbers who have more than 900 value should come in green color.
1. First select range of cells that you want to apply conditional formatting.
2. And go to Home Tab and click on Conditional Formatting Option.
3. Then click HighHight Cell Rules and click Greater than...
4. New Formatting Rule dialog box opens, there you just select Only format cells that contain-->cell value-->greater than-->900(or Select Cell which contains 900 Value)-->Format with: Light Red Fill with Dark Red Text-->Click on Ok.
5.Now those value which has more than 900 values shows in Light Red Background with Dark Red Text.
It is not so easy to explain complete conditional formatting in a single chapter. in the coming tutorials will plan to discuss more about conditional formatting. After watching the video you can download below sample sheet. and it helps you to do practice more. please subscribe for more videos in our youtube channel. if you like our tutorial please share it on facebook and youtube below.
● To Learn Tutorials in a Simple Way.
● To Learn Excel Basics With Downloadable Samples.
● To Learn HTML With Sample Website Code.
● To Learn PowerPoint Presentations.
● To Learn MS Word for Offical use.