|Connect us with

Conditional Formatting in Excel?

What is Conditional Formatting | Apply Rules | Conditional Formatting Example

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.

How to Apply Conditional Formatting in Excel?

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.

Conditional Formatting in Excel-Step 1

3. Then click HighHight Cell Rules and click Greater than...

Conditional Formatting in Excel-Step 2

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.

Conditional Formatting in Excel-Step 3

5.Now those value which has more than 900 values shows in Light Red Background with Dark Red Text.

Conditional Formatting in Excel--Step 4

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 Get FREE Excel Shortcut Keys





Why basictutorials.in ?

● 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.