If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.

How to Keep the Active Cell in Excel. Microsoft Excel 2013 surrounds the active cell with a dark border to help identify the cell you are editing. Pressing the Enter key after editing the cell ...

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.

By using the Highlight Cells Rules, you can highlight duplicate cells in your Excel worksheet to avoid confusion and mistakes.