How To Highlight The Current Row In Excel

How To Highlight The Current Row In Excel
The formula: =ROW(A2)=CELL("ROW")
The code: Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveCell.Calculate
End Sub
formula with a switch: =and(ROW(A2)=CELL("ROW"),$M$6="turn on")
How To Create A Drop-Down List In Excel --- • How To Create A Drop-D...
00:00 - Hello
00:23 - Selecting data using a keyboard shortcut
00:35 - Creating a conditional formatting rule
00:52 - The formula
01:14 - The filling color
01:29 - The first part is complited
01:37 - View code
01:45 - Macrocode
02:01 - Result
02:11 - On/off button with drop-down list
02:50 - Changing the furmula
03:12 - Checking the button

[@mikeleblanc9103]

Works Great! Thank you. I transcribed this into a Word document that I’d be happy to share.

[@Somelittletips-hw5ju]

I'm sorry if the sound in the video is not very good. But the main thing is useful information.

[@aymeetolander]

Such a good idea, thank you! It was easy to follow

[@Somelittletips-hw5ju]

Glad it was helpful!

[@adreamer9999]

Great video tip. Thank you!

[@Somelittletips-hw5ju]

Thanks for the feedback

[@phandongexcel]

I like this video ❤❤❤❤

[@Luciano_mp]

Thanks!

[@Somelittletips-hw5ju]

Thank you for your feedback, I am very glad.

[@BoraHorzaGobuchul]

Problem is, until ms implements this functionality, using these tricks will:
- require vba and hence saving file as xlsm and all the associated security nuances
- and often reset the undo stack as some vba commands do, depending on implementation. Haven't tried this one and looks like it probably shouldn't, but many others do.

[@bluebook01]

Hello thank you for the video and instruction. Question: I noticed when i save the changes after putting "ActiveCell.Calculate" and close the program, then re-open in, i have to always re-enter ActiveCell.Calculate in order for it to work smoothly. Is there any way to have it working smoothly all the time than having to re-enter ActiveCell.Calculate every time i open file? Thank you.

[@Somelittletips-hw5ju]

hello, when you save a document, that is, you do a standard action.
File-->Save as-->This PC(browse)--> and in the menu that appears, in the "save as type" item, select "Excel Macro-Enabled Workbook".
And now you will not have to do all the actions again.
Write later, did you succeed or not?

[@lmcbunnylove]

That is some witchcraft!

[@Somelittletips-hw5ju]

When creating the video, not one witch was harmed :)

[@ROYANTONYABEL]

Voice not clear