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.
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 ]
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 ]
