Conditional Formatting in Excel

Excel, Microsoft Office, Office 365, Premise Online, Conditional Formatting, Excel Sheet, Sheet work.


This article is written over Excel conditional formatting. This is very useful when we are working on large volume of data. We can separate data as per our circumstances. I am here explaining in detail how to mark duplicate data or specific type. Here is as follow:

Step 1: Launch your Excel through shortcut (Windows + R) or launch through program files.

                    run excel

Step 2: Select range where you need to provide conditional formatting in excel sheet.

Sheet Range

Step 3: On Home menu, there is an icon containing conditional formatting, now drill down conditional formatting menu.

Conditional Formatting

Step 4: Now expand sub menu Highlight Cell Rules, then expand more sub menu Duplicate Values…, now click on it.

                                   Highlight Cell Rules

Step 5: Now a popup window will pop up Duplicate Values, Now drill down drop down list, select Duplicate from the list and right side click on values with list, now next select Light Red Fill with Dark Red Text, and click finally on OK button.

Duplicate Values

Step 6: Now on this step, you may check status column, where duplicate is populated light red after conditional formatting.

Status Duplicate

Step 7: Now again another one more formatting of specific word Working is conditional formatting. In the same way above steps, expand Highlight Cell Rules, then expand sub menu Text that Contains…

                                    Text that Contains…

Step 8: Now again a window will popup Text That Contains, now type in text box Format cells that contains the text, in this example Working is typed here, now drill drop down list with, select Green Fill with Dark Green Text, then finally on OK button.

Text That Contains Working

Step 9: Now you can see in the picture where Duplicate, & on specific words conditional formatting is done.



Excel work is very essential to our daily routines work, whenever we are dealing with data volume, analyzing data or put data in systematic way, then conditional formatting plays a vital role in manipulating data. 

Video: Conditional Formatting in Excel


Anjan kant

Outstanding journey in Microsoft Technologies (ASP.Net, C#, SQL Programming, WPF, Silverlight, WCF etc.), client side technologies AngularJS, KnockoutJS, Javascript, Ajax Calls, Json and Hybrid apps etc. I love to devote free time in writing, blogging, social networking and adventurous life

Post A Comment: