How To Highlight Active Row in Excel - Excel Tips and Tricks [fE6PAuk5QbA]
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 #microsoft #excel #exceltips #tips #exceltricks #tricksandtips