Answer to how do I highlight selected cells in Excel. Or is there a way to highlight a row in Excel when selected? I will provide the answers to how do I color selected rows in Excel, or how to change cell color when cell is clicked or selected in Excel?
Here are the steps outlined in my video.
Highlight selected row
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
8) Orange
9) OK
10) OK
11) Right-click on sheet
12) View Code
13) Change General to Worksheet
14) Enter this code
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target.Calculate
End Sub
15) Ctrl + S
16) Close VBA Editor
Is there a way to highlight a row in Excel when selected?,How do I highlight selected cells in Excel?,How do I color selected rows in Excel?,How to change cell color when cell is clicked or selected in Excel?,
Check out my complete suite of Microsoft Excel Tips and Tricks.
https://www.youtube.com/@RabiGurungXybernetics/shorts
https://www.tiktok.com/@xybernetics247
https://www.instagram.com/rabi.gurung247/
https://www.pinterest.ca/RabiGurungXybernetics/excel-tips-and-tricks/
https://twitter.com/XyberneticsInc/media
https://www.reddit.com/r/Excel247/
https://www.facebook.com/XyberneticsInc/reels/
#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks
