In the Code window on the right, paste the above code.In its Microsoft Excel Objects folder, double-click on the sheet in which you want to apply highlighting. If you don't see it, use the Ctrl + R shortcut to bring the Project Explorer window to view. In the Project Explorer on the left, you'll see a list of all open workbooks and their worksheets.In your workbook, press Alt + F11 to get to the VBA editor.To have the code silently executed in the background of a specific worksheet, you need to insert it in the code window belonging to that worksheet, not in the normal module. To only highlight the active column, remove or comment out this line.To only highlight the active row, remove or comment out this line.To get the row and column colored in the same way, use the same color index number for both.To change the highlight color, just replace those with any ColorIndex codes of your choosing. Our sample code uses two different colors demonstrated in the above gif - color index 38 for row and 24 for column.If you'd like to customize the code for your needs, these small tips may come in handy: 'Highlight row and column of the selected cellĪpplication.ScreenUpdating = True End Sub Customizing the code With such notes and colored tabs, people can easily understand they are not in use and avoid referring the unused tabs mistakenly.Private Sub Worksheet_SelectionChange( ByVal Target As Range)Īpplication.ScreenUpdating = False 'Clear the color of all cells In that case, you can make the color of those unnecessary tabs black and leave a note in the file that black tabs are not used. As another example, you may have unnecessary sheets in your file but want to keep them just in case. For example, you can color a revenue summary sheet in red and its back-data sheet in light red, and make the tab color of a cost sheet green, etc. We recommend that you use similar colors for a group of relevant tabs. You can quickly tell what type of sheet you are working on even if you have multiple sheets in a file. It is useful to differentiate tabs by coloring tabs in different kinds of colors. ‍ Why do you change tab color in Google Sheets? In this article, you will learn how to change tab color in Google Sheets.

How to change excel cursor color