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

Please take the opportunity to connect and share this video with your friends and family if you find it useful.