Instructions to automatically color duplicate values ​​in Excel

In the process of working with the Excel application, we often face complex and sometimes repetitive data. This will cause a lot of stress for you at work.

In order to avoid unnecessary errors, the data separation and format is quite important, and I think it is necessary.

Yes, and in today’s article I will show you how to color duplicate values ​​on Excel files with the Conditional Formatting tool.

How to set auto-color the same values ​​in Excel

+ Step 1: You open your Excel file => then click on the value box to color as shown below.

tu-dong-to-mau-cho-cac-gia-tri-trung-lap-tren-excel (1)

+ Step 2: You press Ctrl + A to highlight all text => then click on Conditional Formatting => and choose Manage Rules.

study

+ Step 3: At the dialog box Conditional Formatting Rules Manager => you click New Rule.

study

+ Step 4: Then at the dialog New Formatting Ruleyou choose Format only cells that contain format the cell according to its value.

study

=> Then at Format only cells with you choose Cell valueand equal to ie the value in the cell must be equal to the value you want, next you enter the corresponding content value in the next cell and then click Format.

Example when bouncing in step one you choose Hà Nội to create background color, then here you enter Hà Nội Please.

study

+ Step 5: Dialog box Format Cells appears, click Tab Filland click the color tone you want to fill in the text box, then click OK => and OK to close the dialog New Formatting Rule.

download

+ Step 6: After color formatting for Hanoi Text is done, in the dialog box Conditional Formatting Rules Manager you click Apply => and OK to save the result and exit the dialog box.

See more:  Lesson 113: How to use the IF function in Excel

tu-dong-to-mau-cho-cac-gia-tri-trung-lap-tren-excel (7)

Ok that’s it, now all the cells containing the content are Hà Nội All will be colored as selected.

study

In addition, from now on when you enter Hanoi or Hanoi characters and remove Capslock, Excel will also automatically color them without you having to spend time Resize again.

study

With how to use the tool Conditional Formatting then you can similarly colorize with multiple repeatable values, to easily distinguish them during your work.

tu-dong-to-mau-cho-cac-gia-tri-trung-lap-tren-excel (10)

Very convenient for your work process, isn’t it!

tu-dong-to-mau-cho-cac-gia-tri-trung-lap-tren-excel (11)

Read more:

Epilogue

Ok, so I have finished showing you how to use the Conditional Formatting tool to automatically color the same values ​​on Excelmaking it easier for you to control your input and existing data on your Excel spreadsheet.

At this point, the tutorial on how to automatically color duplicate values ​​on Excel will also be paused. Hope today’s little trick will be useful to you. Good luck !

CTV: Luong Trung – techtipsnreview

The article achieved: 5/5 stars – (There are 2 reviews)

Note: Was this article helpful to you? Don’t forget to rate the article, like and share it with your friends and family!


Source: Instructions to automatically color duplicate values ​​in Excel
– TechtipsnReview

Leave a Reply

Your email address will not be published. Required fields are marked *