From the course: Excel: Financial Modeling with Dynamic Arrays

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Applying dynamic formatting to models

Applying dynamic formatting to models - Microsoft Excel Tutorial

From the course: Excel: Financial Modeling with Dynamic Arrays

Start my 1-month free trial Buy for my team

Applying dynamic formatting to models

“

- [Narrator] One of the limitations of using dynamic arrays that you might have already noticed is that the formatting does not spill automatically across the range. Let me show you what I mean. In this example that we worked on earlier, if we were to change to five, that formatting is still there. If we change it to seven, it looks even worse, so this formatting doesn't spill across. So we can fix this by using conditional formatting. So let's say we want it to go out to a maximum of say, 10 years. So let's go ahead and copy the formatting all the way across, and then what we can do is highlight all of them. Let's say all of them, except for the first one, because we'll always have at least one year, and we'll go into conditional formatting. We'll go to a new rule, and we will say, if the cell value is blank, we would like the formatting to have no orders and the fill to have no color. Okay, let's try that out. All right, so now when I change this back to five, okay, yes, that is…

Contents