From the course: Excel: Conditional Formatting for Beginners
Join today to access over 25,500 courses taught by industry experts.
Format based on formulas - Microsoft Excel Tutorial
From the course: Excel: Conditional Formatting for Beginners
Format based on formulas
- [Instructor] We're looking at the worksheet called Formula-Based Formatting in our chapter one file. And what we'd like to be able to do here is to highlight those entries in column E, the actual sales amounts, that exceed or are equal to the quota that's in column D. We want that to stand out more prominently. And as we select column E and go to Conditional Formatting, Highlighting Cells Rules doesn't really give us that option and neither does Top/Bottom Rules. So what we need to do in some cases is use a feature called a New Rule. In other words, we will establish a new rule based on a formula. Use a formula to determine which cells to format. Now, when I highlighted column E, the act of cell became E1. You see that to the left of the formula bar. We use that in the formula here. And that might seem a little strange if you've never worked with this concept before, but what we're about to say is if the entry in column E is greater than or equal to the entry in column D, let's…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.