1. Click on the developer tab in the menu bar
2. Click on the drop-down arrow below insert
3. Select the rectangular command button from the ActiveX controls
4. Select a convenient location and then click and drag the mouse button to draw a command button
5. Double click on the command button
6. Between the 2 lines of code that you will see in the Visual Basic Editor (VBE) Window just copy and paste the following code:
7. Now close the VBE window and come back to your Excel worksheet
8. Click on the developer tab in the menu bar
9. Click on 'Design' to exit the design mode
10. Now click on the Command Button1
11. The relevant row will be highlighted purple and if the first cells values are 2 then the font of the value 2 will become white
Bookmarks