From the course: Excel Spreadsheet Design: Extreme Makeover

Unlock the full course today

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

Distinguish results with conditional formatting

Distinguish results with conditional formatting - Microsoft Excel Tutorial

From the course: Excel Spreadsheet Design: Extreme Makeover

Start my 1-month free trial Buy for my team

Distinguish results with conditional formatting

“

- [Instructor] Looking at this whole of life costing for the purchase of a new car, what are the things that matter? Just like driving a car, wouldn't it be great if we had some kind of traffic lights to tell us whether to stop or go? Well, with Excel's conditional formatting, you'll be on the road in no time. I suggest having the exercise file open for this movie to follow along with me. In this lifecycle costing scenario, for the purchase and maintenance of a new car, our estimate comes out to $56,320. Now, we've set a budget of $63,000, so in theory, we're good to go with this purchase. In fact, the difference calculation here tells us exactly that. We're under budget by just over $6,500. But unless you know what you're looking for, this number could get lost with everything else on the worksheet. So let's spruce it up. Make sure that cell C15 is selected. And then go ahead and click on the dropdown box next to…

Contents