Hey team, In this video we cover how to highlight the entire active row in Excel based on your cell selection. Formula used in conditional formatting: =row()=cell("row") VBA code used: Target.Calculate
@@CareerSolutionsforToday Someone needs to Talk about this How can I get to Show *VIEW CODE* when I Right Click on Tab I don't get it when I Right Click on Tab :( Please
This is great and your vids are so easy to follow Is it possible to highlight the row when only selecting the cells in one column (such a col A). Reason been that I may only want to highlight the row on occasion rather than every time I selecta cell in the range.
Hey so after researching and thinking about it a bit. Not sure there would be a way to easily set it up for the entire workbook as you need to apply the conditional formatting to each tab. I will keep thinking about it but wanted to let you know.
@@CareerSolutionsforToday I appreciate it. It seems like something that MS should include as a one-click option, for ANY sheet, or book. I for one, often have to just go to the left margin and highlight the entire row, but you know how long that lasts LOL. I appreciate your videos. p.s. I'm still trying to get the signature with no background to work. Have a great week.
Thanks! On saving, I get a prompt saying I need to store the workbook as a .xlsm format. Can it be stored as an .xlsx while still containing a VBA module? Liked and subscribed 👍.
@@CareerSolutionsforToday Okay, thanks. I remember the days of Office where you could save a .docx or .xlsx file with VBA macros included. I guess the security risks were too high and MS discontinued that practice. Chalk up another one for the bad guys.
Make sure you try the right click on the tab. Also make sure you are using the app version of Excel instead of the web version. Let me know if this helps =)
Excel for the Web doesn't allow you to write the VBA code but it should run the VBA code macro you created if you did so in the app version. Let me know if this helps =)