Menu
How to design a sheet script that would result in an active row being highlighted?
I would like to have an entire row change color of font or background when one cell in that row is active.
I don't want the trigger to be any specific value in the cell, just clicking on a cell should trigger the highlight for the whole row that cell belongs to.
739
Go to the Home tab. Click on Conditional Formatting and then click on New Rule. In the New Formatting Rule dialog box, select “Use a formula to determine which cells to format”. In the Rule Description field, enter the formula: =OR(CELL(“col”)=COLUMN(),CELL(“row”)=ROW())
1. Open the worksheet you will auto-highlight the row and column of active cell, right click the sheet tab and select View Code from the context menu. 3. Then press the Alt + Q keys together to return to the worksheet, now when you select a cell, the entire row and column of this cell has been highlighted.
The best you can get to highlight the selected row and/or column without VBA is Excel's conditional formatting. To set it up, carry out these steps: Select your dataset in which the highlighting should be done. On the Home tab, in the Styles group, click New Rule.
Sorry, this can't be done with conditional formatting or script by just selecting a cell. You can, however, highlight an entire row of the active cell with the key combination Shift+Spacebar.
184
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
