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? <br /><br />Here are the steps outlined in my video. <br /><br />Highlight selected row <br />1) Ctrl + A <br />2) Home ~ Style ~ Conditional Formatting <br />3) New Rule <br />4) Select "Use a formula to determine which cells to format". <br />5) =ROW()=CELL("ROW") <br />6) Format <br />7) Fill <br />8) Orange <br />9) OK <br />10) OK <br />11) Right-click on sheet <br />12) View Code <br />13) Change General to Worksheet <br />14) Enter this code <br />Private Sub Worksheet_SelectionChange(ByVal Target As Range) <br />Target.Calculate <br />End Sub <br />15) Ctrl + S <br />16) Close VBA Editor <br /><br /><br />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?, <br /><br />Check out my complete suite of Microsoft Excel Tips and Tricks. <br />https://www.youtube.com/@RabiGurungXybernetics/shorts <br />https://www.tiktok.com/@xybernetics247 <br />https://www.instagram.com/rabi.gurung247/ <br />https://www.pinterest.ca/RabiGurungXybernetics/excel-tips-and-tricks/ <br />https://twitter.com/XyberneticsInc/media <br />https://www.reddit.com/r/Excel247/ <br />https://www.facebook.com/XyberneticsInc/reels/ <br /><br />#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks <br />
