![]() How to highlight the duplicates and overlapping dates in Excel?.How to conditional formatting values not between two numbers in Excel?.Then you can highlight the cells with the background color. The diagonal cells in the selection have been selected. Press F5 key and a dialog pops out to remind you to select cells, type the number of diagonal cells you want to select in the textbox.Ĥ. Set xRg = Union(xRg, ActiveCell.Offset(I, I))ģ. XCount = Val(InputBox("How many cells do you want to select diagonally?", "KuTools For Excel")) VBA: Select diagonal cells Sub selectDiag() Click Insert > Module and paste below code to the script. Select the cell you want to start the diagonal selection and press Alt + F11 keys to enable the Microsoft Visual Basic for Applications window.Ģ. To select diagonal cells, you can use a macro code.ġ. In Excel, we usually need to select multiples cells, but have you ever tried to select and highlight the diagonal cells in a range? In this article, I will introduce a VBA coed to quickly select diagonal cells for you. ![]() How to select and highlight diagonal cells in Excel?
0 Comments
Leave a Reply. |