Formula Friday – How To Highlight All Cells Containing A Formula In Excel


Hello, it is time for some more #formulafridayfun. Today I want to share with you how to highlight all cells containing a formula. It is a question a colleague asked me this week. It was a great question!. How can I see at a glance by changing the colours of the cells, my cells that contain formulas?. That would be a handy Excel tip, especially if you have a large worksheet and need to know at a glance.

I found a really easy way to achieve this with a few clicks. Follow the instructions below to highlight cells with formulas.

Learn Excel With Our Excel Online Courses
  • Home Tab
  • Editing ribbon
  • Hit small arrow next to Find and Select
  • Select GOTO – Special
  • Select Formulas
  • Hit Ok
FORMULA FRIDAY HIGHLIGHT CELLS THAT CONTAIN A FORMULA
  • Home Ribbon
  • Cells
  • Format
  • Select the colour you want your cells to be highlighted- in this example it’s yellow
FORMULA FRIDAY HIGHLIGHT CELLS THAT CONTAIN A FORMULA1

If you want to use an Excel keyboard shortcut to access the GOTO Special dialog box then simply hit the F5 key. This brings you to the same dialog box.

All of your cells containing formulas will be highlighted. Why not give it a go. Prefer to watch a video tip?. Watch my YouTube video on how to highlight all cells that contains a formula below.

Watch The Video. Highlight All Cells Containing A Formula


If you want more Excel and VBA tips then sign up to my monthly newsletter. I share 3 Excel Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips.

If you want to see all of the blog posts in the Formula Friday series you can do so by clicking on the link below.

How To Excel At Excel – Formula Friday Blog Posts.

 

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts