In this workout, we practice using conditional formatting. What we want is that when the linked cell here has a one in it, we want to use the best case scenario, and we want it to be colored green. So it's really obvious that that's what we're using. If the linked cell has a two in it, we want to use the base case, and if the linked cell has a three in it, we want to use the worst case. What we've done is we have hidden a one, a two, and a three into cells C8, C9, and C10. What we have to do, first of all, is select the cells we want to be green, and we're now going to conditional formatting. The shortcut that is alt H L R.

It now asks me what to want to do, and I want to apply a new rule. I'm going to click on User Formula to determine which cells to format, and this is where I now have to come up with a formula myself. I'm gonna say is that I want the rule to be when C8 equals D5.

But I have to be very careful here. I want to get rid of the dollar just before the eight, so that I can copy this formatting down later on. If I'd left the dollar there, then this would only apply to C8 and D5.

Great. I now choose my formatting. I want it to be green. And that is my rule created. So I press Okay, and that has worked. Let's change the linked cell from a one to a two, and the formatting has gone away. Change to a three, it's gone away. Now the actual offset function is working here. It is returning the 3% here. If I choose a two, it is working. It's taking the 6% from here, but we haven't applied the conditional formatting yet. We've only applied it to the best case when we've got a one. So what I'm gonna do now is I'm going to copy that top line, and I'm now going to paste special that into the lines below. So shortcut for paste special, control alt V, and I want to paste formats. So I press Okay, and let's check to see if it's worked. Let's change that linked cell to a two. I should get a 6% down here, and I should get green in the second line. Fantastic, that has worked. Let's change it to a three. Let's see what happens. Brilliant. We've now got 3% at the bottom, and we've got green highlighting in our worst case scenario.