You can use a different border to highlight important data.įill: In the “fill” option, there is a different colour option available for formatting the data. Number: In the “number” tab, you can format the cell among different available options such as general, number, currency, accounting, date, time, percentage, fraction, etc.įont: In the “font” tab you can select a different font, font size, andīorder: In the “border” tab there is a different option available for a border. In format cells dialog box, there are four options available Than “12,000” which will get highlighted by green colour. 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.
#Conditional formatting definition excel how to#
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.