Highlight All Excel Formula Cells

Whenever you are auditing an Excel worksheet and need to know where all the formulas are located, a great way is to highlight the formula cells in a distinctive color.  This is how it is done:

STEP 1: Select all the cells in your Excel worksheet by clicking on the top left hand corner of your worksheet.

STEP 2: Press the CTRL+G shortcut which will open up the Go To dialogue box and select the Special button.

STEP 3: Select the Formula radio button and press OK.

STEP 4: This will highlight all the formulas in your Excel worksheet and you can use the Fill Color to color in the formula cells.

And now all your cells containing formulas are now highlighted!

You can practice this cool trick by downloading this workbook:

Download excel workbookHighlight-all-Formula-Cells.xlsx

Further Learning:

• Conditionally Formatting A Drop Down List
• Conditionally Format a Pivot Table With Data Bars
• Pivot Table Conditional Formatting

John Michaloudis

Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.