Despite the fact that there are so many technological innovations in our days, the Excel office software does not go out of style . It has so many features such as inserting images in the cells , or changing their size, which thousands of users around the world love.
Likewise, the color coding in the cells is also possible in this program and today we will teach you how to comply with this procedure effectively.
How to add the color code in EXCEL to personalize my data?
Index( )
- How to insert color code in Excel with basic options?
- highlight duplicates
- sort by color
- Mark the top 10
- What advanced options are presented in Excel to use the color code?
- Point out variations with data bars
- Mark negative, positive and neutral data
- Scale of colors
How to insert color code in Excel with basic options?
First of all, you have to know that inserting the color code in Excel requires some planning before making the changes in the spreadsheets . Whether you use the online version or the desktop version, you have to make sure that the encryption is really necessary.
All this, so that the change in intensity of the tone adjusts to your personal preferences. In any case, here we indicate the options that will help you to fulfill this task.
highlight duplicates
Highlighting duplicates with color is extremely useful when you want to eliminate duplicate names or when you want to perform a deeper analysis of the document in Excel . For this reason, the first thing you should do is choose the cells of your interest, pressing Ctrl + A. Then, you will go to the Start window until you find the Conditional Formatting tab in the options panel.
Once you are there, you will need to click on the tab that says Highlight Cell Rules and on Duplicate Values. Now, you are going to select the type of cells that you want to highlight, they can be the duplicates or the only ones. Finally, it remains for you to opt for one of the available colors that appear on the panel and when you are satisfied with your decision, you just have to press Ok to save the changes.
sort by color
If you already know how to merge and split cells in Excel , you probably want to learn how to add color when it comes to long lists to sort them .
To comply with this, you have to select the cells you want to modify and access the Data section, pressing on the Sort and filter option and then on Sort. Next, you have to choose the data column and when you click on Sort by, all the colors available for the cells will appear.
So, select the color that you like the most and then click on the alternative that says On top . To finish, you just have to click on the OK box so that the list is sorted and the colors of the duplicates can be seen without any problem.
Mark the top 10
Now, you may want to highlight the top 10 of a list so that its main elements stand out in style and you can print it correctly . So, you have to go to the Home tab and look for the Conditional Formatting option. From this section, we see that the upper / lower Rules option appears, so click on it and choose the 10 main articles to apply the color.
Please note, that in this pop-up window you have the possibility to select more or less than 10 items within your list . In addition, you can opt for any of the more striking colors to create more visual appeal. As soon as you finish making all the modifications, all you have to do is press OK to save the changes within the system.
What advanced options are presented in Excel to use the color code?
You already know the basic options for color coding within Excel spreadsheets. Therefore, you need to know those more advanced functions that will help you succeed in your task. Of course, because they are advanced does not mean that they are very difficult to carry out. So, don’t worry because with these simple steps you will be able to achieve your office purpose in a simple and enjoyable way.
Point out variations with data bars
Showing variations with data bars is a really simple process that will allow you to draw a bar for each of the cells present in your document.
To get a result like this, you have to go to the Home tab, looking for the Conditional Formatting section and then clicking on the Data Bars part. Then, you just have to choose the color of your interest, the style of the fill and that’s it. It’s that simple!
Mark negative, positive and neutral data
To highlight elements of your Excel document, such as negative, positive and neutral data, you have to select the column of your interest.
Next, you are going to go to the Home tab and then you will click on Conditional Formatting and then Icon Set . From here, you have to choose the icon style that you like the most so that the program starts working automatically and that’s it.
Scale of colors
Another great advantage of using Excel is that you can show variations with color scales in order to obtain personalized and high quality results .
To do this, you have to select the range and access the Conditional Formatting panel again from the program’s Start window. Then, all you have to do is click on the Color Scales section and choose the colors you like within the box, confirming your decision by pressing OK.
