00:00One of my colleagues was asking, how do you highlight a selector cell so that he can clearly see where his cursor is, even if the spreadsheet does not have focus?
00:09So this is how you do it. First, you're going to select the whole dataset table by pressing Ctrl-A, once like this, and then go Home, Style, Conditional Formatting, New Rules.
00:19Over here, you're going to select Use Formula, and this is the formula you'll be using.
00:23Once that's done, go to Format, and then make sure you are selecting Fill Tab here like this, and then select some color that stands out from your spreadsheet.
00:35I'm going to select, say, Red, go OK, and then OK one more time.
00:41At this point, you will have only one cell selected like this, and it's not moving at all.
00:45So to animate the cursor, go right-click here on the sheet, and go View Code, and this VBA text editor will appear.
00:53Make sure that your correct sheet is highlighted here on the left-hand side of the tree, and then from this general here, you're going to pull down and select Worksheet.
01:03Over here, you're going to type Target.Calculate like that, and press Ctrl-S to save whatever you have edited here.
01:12And let's close the VBA editor, and now if you click anywhere on your spreadsheet, the highlight moves along with it.
01:19And even if you have another app on top of it, like for example, if I open a notepad like this, you can see that the cursor is still highlighted.
01:27And even if you drag in another app, maybe a browser like this, your cursor, wherever it is right now, is highlighted.
Comments