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 DropDown List In Excel • How To Create A DropDown List In Excel
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 dropdown list
02:50 Changing the furmula
03:12 Checking the button