Skip to content

How to Make Excel Change Cell Color Automatically with Mobile and PC

9 de March de 2022

Microsoft Excel is perhaps the most powerful tool within the complete Office suite and its popularity and functionality have reached such a point that some jobs require knowing how to handle Excel at an intermediate level as one of their requirements.

You can download Excel from its website, as well as use its online version or also buy the physical version together with the other Microsoft Office programs. In this article we will teach you how to change the color of a cella number or letter depending on the case, but automatically, taking into account some conditionals.

How does conditional color formatting work in Excel?

The “Conditional Formatting” function It is used to place a specific type of color and/or font to cells that contain values ​​that meet certain conditions. These values ​​can be both letters and numbers, so it is possible to change the color of a row based on the text or the number.

This option is found in the “Home” tab, “Styles” option and in “Conditional formatting”, by doing this, you will see several main options that will change the cell format according to the conditions you specify, at the end of everything , you will be able to elaborate your own rules with even more detailed conditions if you need it and then apply them as many times as you need.

Once you place your ruler and format, at select the corresponding cells and accept, all those that meet the condition you placed, will be affected by the format, the rest will not.

What are the criteria for using conditional formatting in your Excel documents?

There are some aspects to take into account before changing the color of a cell with Conditional Formatting, otherwise, it is possible that when trying to apply the formats, there may be errors and the changes will not be applied.

applying colors to cells in excel

Have the data organized and in a single table

It may be a platitude, but it is important to highlight it, all the data must be properly organized and ordered, that is, if they correspond to a row or column, those of the same class must be there and not in random cells. The same if you have several tables within the same spreadsheet, if certain data corresponds to a table, they must remain in it.

This must be so, since when applying the rules, you must select the area where the data to modify the format is located and it will be easier for Excel if they are grouped.

Have a similar criteria (numbers or letters)

The criterion, rule or condition to be established must be according to the data found in the cells, that is, if you want to change the format following a numerical conditional, the cells must have numbers and the same applies to the case Of letters; otherwise, Excel won’t be able to recognize the command and therefore won’t change anything at all.

How to automatically change the color of a cell in Excel?

Once you have all the data in order and organized, the first thing you will do is select those that will suffer the change of formate, be it an entire row, column, or combination of these. Now you go to “Home” > “Styles” > “Conditional Formatting” > “New rule” or “Manage rules”.

In the new dialog box, we choose the option of “Format cells only that contain” and here you will establish the conditionals according to value, text, dates, errors, without errors and choose the format, if you change the color of the cell, change the color of the text and its style.

automatically changing cell color in excel

According to the text

When we choose this option, we will be able to change the color in a cell according to the text that begins with a specific letterthat it ends, that it contains and that it does not contain, in the box that is right next to it we will specify the above and when we have specified the format and everything, we click on “Accept” or “Apply” and the change will be made to all those cells that meet our rule.

In the event that we want to change this text rule for another, in the “Manage rules” option we can make the corresponding edition, from here there is also the alternative to delete or add new conditions.

Depending on the value

If it is numbers, then the option we choose will be “cell value” and next to it we will have the action to perform: between, is not between, equal to, not equal to, greater than, less than, greater than or equal to, and less than or equal to. In this sense, you have to be much more specific than the previous case and then specify the corresponding values.

When you have established everything, including the format, the process is the same, before having selected the cells, you apply your rule and all those that meet your condition will change their format.