How to Modify Active Cell Color in Excel? – Locate Data

The Excel tool offers all its users the option of active cell color change, Applying this option is highly recommended, since it helps to locate data more quickly, if you still don’t know how to change the color of the active cell, stay here because we will explain how to do it:

What is the procedure to change the color of the active cell in excel?

The active cell is the one that informs which of the cells of an Excel text sheet is ready for you to enter either a text or a formulait is identified with a highlightsaid cell, in addition to the highlight, has a white fill in the lower part which can be modified, the process to achieve it will be shown below:

1. The first thing you should do is save the document on your computer. macro enabled. To achieve this when you are saving the document in the Types option press on the Excel Workbook option enabled for macros, this option will be shown if you have the macro for Excel files enabled, if you do not have it you must activate it
2. In the open Excel document click on the inverted triangle in the upper left corner.
3. Go to the Home section, in it find and select the Conditional formatting option, In the menu that will open, select the New rule option.
4. On the new page that will be shown you should look for the option Use a formula to determine the cells.
5. At the bottom of where it says shape values ​​place =cell(“address”)=address(row();column()).
6. Click on the Format option, you will be given a panel where you can select the color of the cell, the font, the border, among other options.
7. When you finish the configuration, click on the Accept option.
8. Proceed to right-click on the name of the sheet that is at the top, in the menu that will be shown select the option Show code.
9. In the new window, select the name of the sheet you are working on, then select the General option on the right side and click on the Worksheet option.
10. Now click on the Declaration window Change Selection option.
11. In the same window at the bottom of private place the target.calculate code.
12. Find and press the save icon and then close the window.
13. Next you will return to the worksheet, there with your mouse you will be able to see that when moving it through said sheet the selected cells will mark with the color that you selected in the process.
14. If you want the color of the active cell to be seen in a group of cells, you must select with your mouse in which range you want it to be seen, then go to the Home section, once there look for the conditional formatting option in the options that are they will give you new rule.
15. Select the option Use a formula that determines the cells, in the space that will be given to you, place the code =CELL(“ADDRESS”)=ADDRESS(ROW();COLUMN()), press accept and voila.

How do you change the row and column color of the active cell?

To make it easier for you to read either an inventory or stock control, you can apply color to the row and column of the active cell, achieving this is possible by means of Kutools for Excel tool, which you must download and install on your computer.

Once you install it, it will appear in all the Excel documents that you open on your computer, its specific location is in the toolbar, You must activate it whenever you are going to use it., activation is simple, you just have to click on its tab and then on the Reading Design option. From this activation the color of the row and column of the active cell will be changed.

How to highlight active cell in Excel without macro?

Without a macro it is also possible to highlight the active cell, below will show you the procedure to achieve this highlight:

1. The first thing you need to do is highlight the range in which you want the active cell to be highlighted.
2. Now go to the Home section, in it look for the Conditional Format option then select the option Use a formula to determine the cells.
3. In the space provided, place the code =AND(ROW()=CELL(“row”);COLUMN()=CELL(“column”)).
4. After the above, access the Format option, a new window will open in it, define the color of the highlight fill, the font and the size when you finish press the Accept option. After this, the active cell will be marked with the color you selected.

Why isn’t the color of a cell I changed reflected?

If you already applied one of the previous methods to modify the color of the active cell in Excel and it did not work for you, it is probably for one of the following reasons:

The cell is protected from edits

In Excel you can lock cells, columns and rows consists in avoiding any edition in any of themif you are trying to use color highlighting on an active cell that has a lock it will not be possible as long as it has this lock.

You have double clicked on the cell

If you click twice in a row on an active cell highlight will not showfor an active cell to be marked with the highlight color you must click only once.