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.
+ Step 2: You press Ctrl + A
to highlight all text => then click on Conditional Formatting
=> and choose Manage Rules
.
+ Step 3: At the dialog box Conditional Formatting Rules Manager
=> you click New Rule
.
+ Step 4: Then at the dialog New Formatting Rule
you choose Format only cells that contain
format the cell according to its value.
=> Then at Format only cells with
you choose Cell value
and 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.
+ Step 5: Dialog box Format Cells
appears, click Tab Fill
and click the color tone you want to fill in the text box, then click OK
=> and OK
to close the dialog New Formatting Rule
.
+ 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.
Ok that’s it, now all the cells containing the content are Hà Nội
All will be colored as selected.
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.
With how to use the tool Conditional Formatting
then you can similarly colorize with multiple repeatable values, to easily distinguish them during your work.
Very convenient for your work process, isn’t it!
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
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