Look Who it Was Random video

Excel - Apply a Highlight Color to all of the Precedents of This Cell in Excel - Episode 862

3,270 views · Published 7 January 2009 · 1:51 · Indexed 4 November 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Apply a Highlight Color to all of the Precedents of This Cell in Excel.

Welcome back to the MrExcel netcast! In today's video, we're going to be talking about a handy Excel feature that you may not know about - color precedents. But before we dive into that, I wanted to let you know about some upcoming seminars that I'll be hosting. On October 14th and 15th, I'll be in St. Louis, Missouri and Columbus, Indiana. If you're in the area, I would love to see you there! And for those of you in Wisconsin, mark your calendars for November 10th, where I'll be hosting two seminars in Waukesha and Stevens Point. I hope to see you there!

Now, let's get into today's topic - color precedents. This feature is especially useful for those of you who work with large formulas. Have you ever pressed F2 on a formula and noticed that all the cells involved in that formula are highlighted in color? Well, what if you want to keep those cells highlighted even after you're done editing? That's where color precedents come in. 

To access this feature, simply press Ctrl+G to bring up the go-to dialog box, then click on "Special" and select "Precedents". You'll have the option to choose between "Direct only" precedents, which are the cells that were originally highlighted, or "All levels", which includes the precedents of the precedents. Once you've made your selection, click OK and then use the Paint Bucket icon to choose a color. This will effectively format all the precedents of the original formula. Keep in mind that this will only highlight cells on the current worksheet, so if you want to highlight cells in other worksheets or workbooks, you can use the Trace Precedents feature.

Thanks for tuning in to today's netcast from MrExcel. I hope you found this tip helpful and will start using color precedents in your own Excel work. Don't forget to like and subscribe for more Excel tips and tricks. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Dan from Texas asks: is there a way to change the color of cells that are precedents of a particular formula. Use the technique in Episode 862 to quickly complete this task.

Table of Contents:
(00:00) Introduction and Upcoming Seminars
(00:41) Question from David in Texas
(00:54) Highlighting Cells in a Large Formula
(01:30) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Columbus, Indiana
Ctrl+G (go-to dialog box)
Highlighting cells in color
Indianapolis
Louisville, Kentucky
MrExcel netcast
Paint Bucket icon
Precedents
St. Louis, Missouri
Stevens Point, Wisconsin
Upcoming seminars
Waukesha

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1152008/

More from this channel