How To Highlight Active Row in Excel - Excel Tips and Tricks

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

#shorts #short #shortvideo #fyp #excel #microsoft #tiktok #fypシ