MrExcel's Learn Excel #862 - Color Precedents

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Jan 7, 2009.
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.
maxresdefault.jpg


Transcript of the video:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
I want to point out a couple of upcoming seminars here, October 14th and 15th, I'll be in St.
Louis, Missouri, and then over in Columbus, Indiana.
Now, Columbus is an easy drive from either Indianapolis or Louisville, Kentucky, so love to see you there.
And then, Monday, November 10th, doing two different seminars on the same day-- in the morning, first thing, at Waukesha, and then the afternoon, up in Stevens Point, Wisconsin.
So anyone up in the Wisconsin area, I'd love to have you drop by.
Today's question comes from David in Texas.
David said, "You know, hey, if you have a large formula and you press F2 on that formula, it will highlight all of the cells in color.
But how would you do something to keep those cells highlighted after I'm done editing?" And there's a cool way to do this.
I'm going to press Ctrl+G to get to the go-to dialog box, click Special, and then click Precedents.
Now, I have a choice: Do I want the "Direct only" precedents-- which are the ones that were lit up-- or "All levels"-- so, then the precedents of the precedents?
I'm going to choose direct only; click OK; and then I, simply, from the Paint Bucket icon, choose a color, and I've effectively now formatted all of the precedents of that original formula-- at least the precedents that are on this worksheet; it doesn't highlight things in other worksheets or in other workbooks, you could use Trace Precedents for that.
I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel.
[ music ]
 

Forum statistics

Threads
1,213,558
Messages
6,114,297
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top