Learn how to highlight active row in Excel.
Here are the steps outlined in the video.
1) Ctrl + A
2) Home -- Style -- Conditional Formatting
3) New Rule
4) Select "Use a formula to determine which cells to format".
5) =ROW()=CELL("ROW")
6) Format
7) Fill tab.
8) Select yellow colour.
9) OK
10) OK
11) Right-click sheet. View Code.
12) Select Worksheet
13) Enter
Target.Calculate
14) Close Code editor
How do I keep a row highlighted in Excel when scrolling?,Can I make Excel highlight the active row?
auto highlight active row in excel,how to highlight active row in excel,how to keep row highlighted in excel when scrolling,how to highlight active row and column in excel,highlight active row and column in excel without vba,highlight active row in excel vba,how to highlight active cell in excel,how to highlight cursor in excel,highlight row,
