Here we are looking at our assumptions, but assumptions always need to be formatted so that the boss or anyone else I send this to, knows that these numbers are hard-coded assumptions. Let's go to the info sheet where we can see the formatting that's been suggested to us. I can see that we've got formulas. Any calculation or any formula we do is always black font on a white backgrounds. But then for hardcoded numbers, we've actually got two different formats we can use. The first one called hardcoded we use that for historical numbers or facts, but the one above called inputs, we also use for hardcoded numbers. But these are numbers that can change. They're often projections or estimates or assumptions. So the one below hardcoded historical facts do not change, whereas the input formatting as it's called here, that is designed to change. So I need to choose which of these I want to use. Well, back to the budget tab. I have to ask myself, might these numbers change? Might my boss send me an email saying, ah, everything's changed. That is possible. These are not facts. So we're going to use the blue fonts, blue background, and a blue border. Now I need to actually use them. So I'm gonna open up my ribbon and we'll do this a couple of times. And each time we'll do it a little bit faster, show you a more efficient way to do it. So I've got C26 selected, and firstly, I go up to my font color, click the dropdown, and I want a nice deep blue. I'm going to choose this one in the bottom left hand corner, but you may choose a different blue. It really doesn't matter which one you go for.

Next I go up to the fill color. I want to choose a nice light blue here. I'm going to go for this bottom right hand one, but you can choose any one here. It really doesn't matter which one, as long as it's nice and light. And then lastly, I go to borders. Now for the borders, I can't choose any of these that already exist. So I'll go to the very bottom because I want to apply a color. So I click on more borders and it's the bottom left style I want. And the color I want, I'm going to go for something a little bit darker than the background. Lastly, I need to apply it. In this case, I'm going to click on outline and then press okay. And that looks really nice.

Now for the second cell, you might notice that these buttons at the top here are now already set to the last thing I did. So I could just click on the eight for the font, click on the background fill color for the border. I click on it. It takes me into the dialogue box. I just need to click on outline.

Saving me a bit of time already.

Lastly, how else could I have done this? Well, I'm going to undo, I'm gonna press Ctrl Z or control Z, and I could have selected all the cells I wanted to apply the formatting to. So again, click on font color, click on fill color, click on border. I'll have to choose my color again. And I click on outline. But also now I need to click on inside so that it selects the lines in between the cells press. Okay, and that's looking really good.