From the course: Excel: Building a 13-Week Cash Flow

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Conditional format error checking

Conditional format error checking - Microsoft Excel Tutorial

From the course: Excel: Building a 13-Week Cash Flow

Start my 1-month free trial Buy for my team

Conditional format error checking

“

- [Instructor] Okay, so let's go ahead and finish up our error checking exercise and then we'll get back to the cash flow forecast. And we're just going to delete these extra rows that I showed you in the last video. Again, the master error check cell, it's going to encapsulate everything that we've entered below. So what I want to add here is some conditional formatting. I want these errors to be loud and obnoxious when there's an issue. So let's bring up the conditional formatting menu. It's alt H, L to bring it up. First thing is highlight the cell rules. We're going to say if it's equal to a zero, which basically it should be if everything is correct, well then I want that to be green, right? That's nice and calming to my eye. Green fill with dark green text is one of the standard formats that you can choose. So I'm going to click OK. And then we're going to do another conditional format, which is if it's not equal to zero. So ALT H, L brings up conditional formatting. We're going…

Contents