Working
Let’s understand with the working help of the example below (Table1: Sales Report)
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/07/NP-1.jpg)
Table 1: Sales Report
We have 2 Tab’s for conditional formatting i.e. Conditional_Formatting_1 & Conditional_Formatting_2
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/07/NP-2.jpg)
Figure 1.1 Conditional_Formatting_1
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/07/NP-3.jpg)
Figure 1.2 Conditional_Formatting_2
Let’s apply conditional formatting on the below table (Conditional_Formatting_1 tab)
Step 1: Select the data(D2:H13)
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/07/NP-4.jpg)
Step 2: Go to Home tab
Step 3: Click on Conditional Formatting in the Styles group
Step 4: Click on New Rule
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/07/NP-5.jpg)
Step 5: Select Format all cells based on their values
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/07/NP-6.jpg)
Step 6: Select Icon Sets from Format Style and select Icon Style
Step 7: Select the Type as number and enter the value as mentioned in the image.
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/07/NP-7.jpg)
Step 8: Based on the criteria we get the below results.
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/07/NP-8.jpg)
Let’s apply conditional formatting on the below table (Conditional_Formatting_2 tab)
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/07/NP-9.jpg)
Step 1: Select the data(D2:H13)
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/07/NP-10.jpg)
Step 2: Go to Home tab
Step 3: Click on Conditional Formatting in the Styles group
Step 4: Click on New Rule
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/07/NP-11.jpg)
Step 5: Select Format all cells based on their values
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/07/NP-12.jpg)
Step 6: Select Icon Sets from Format Style and select Icon Style
Step 7: Select the Type as number and enter the value as mentioned in the image.
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/07/NP-13.jpg)
Step 8: Based on the criteria we get the below results.
![](https://careergrowthdevelopment.com/wp-content/uploads/2022/07/NP-14.jpg)
Scope of Usage
ü Can be use for management reporting
ü Can be used to add visual appeal to reports
ü Can be used to highlight cells in a table
ü Can be used to choose and apply selected colour
ü Can be used to use icon styles
ü Can be used to use format styles
ü Can be used to define rules or criteria