Excel's checkboxes seem like a very simple feature on the surface—which is probably why they're often overlooked. But when used properly, this underrated feature can transform your spreadsheets into ...

That cell’s fill color is set to Cyan (a neon blue). rngOld, which is the previous active cell is set to nothing—in effect, removing the temporary format. Finally, rngOld is set to Target.