How To Highlight Active Cell In Excel - Excel Pro Trick

 CELL("address")=ADDRESS(ROW(),COLUMN())

To highlight the active cell in Microsoft Excel, you can use conditional formatting. Here are the steps:

1. Select the cell or range of cells you want to highlight.
2. Click on the "Home" tab in the ribbon.
3. Click on "Conditional Formatting" in the "Styles" group.
4. Select "New Rule" from the drop-down menu.
5. In the "New Formatting Rule" dialog box, select "Use a formula to determine which cells to format."
6. In the "Format values where this formula is true" field, enter the formula "=CELL("address")=ADDRESS(ROW(),COLUMN())"
7. Click on the "Format" button and choose your desired formatting options (e.g., fill color).
8. Click "OK" to close the "Format Cells" dialog box.
9. Click "OK" again to close the "New Formatting Rule" dialog box.