How to automatically highlight largest cell in Excel

⁣Learn how to set up formatting rules in Excel to automatically highlight the largest cell value.

Using conditional formatting Excel can detect the largest value in a range of cells and highlight the largest value cell.

Step 1: Click Conditional Formatting
Step 2: Click 'New Rule'
Step 3: Click 'Format only top or bottom ranked values'
Step 4: Adjust 'format values' and 'Preview' as required