The main trick is to make Excel recalculate the worksheet whenever you switch to another cell. Conditional formatting which uses the selected cell location as a condition plus a little VBA to make Excel do some extra work. We’ve included some debugging tricks below.ĭynamic highlighting by selection has two ingredients. Once you get it working, it’s great but that first try can drive you a little crazy. This trick has several steps and can be frustrating at first. The Cell() function is essential and was introduced in Excel 2007 for Windows and Excel 2011 for Mac.īefore we start, a little warning. This highlighting trick makes entering team scores more reliable.Īny modern Excel for Windows or Mac can do this. Managing the scores with all the noise and confusion of an event can be difficult. We used this trick for a Trivia Quiz worksheet. That’s especially important when you’re filling in the table gradually and in a random order – choosing the right cell is important. Large Excel tables can be hard to navigate and ensure you’ve selected the right cell. We’ll also explain the workings so you can change the highlighting to suit yourself. There are many different variations on this method two colors, headings only, cell only etc.
Here’s obvious and more subtle highlighting options plus the downside of highlighting, real world tips and debugging tricks if you’re having trouble. You can make it easier to see your current place in a workbook by dynamically highlighting the selected row, column, cell or headings.
0 kommentar(er)
