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,
