![]() Step3: Click on fill → select the color of your choice → click okĪfter clicking on the ok button, the values which are greater Step2: Enter the value → click on a custom format Step1: Go to Home tab → select the data → click on conditional formatting → click on highlighted cells rules → click on greater than Steps to apply conditional formatting in excel are given below: ![]() Suppose you have expense data of your employee and you want to highlight the expense of the employee whose total expense is more than 12,000. Case1: Highlight the cell whose value is greater than 12,000. Let’s learn how to use condition formatting in a different scenario. Conditional formatting can be applied in multiple ways to analyse the data. Conditional formatting is an important tool to visualize the data and it automatically applies formatting such as color, data bar and different icon to the selected cell.
0 Comments
Leave a Reply. |