From the course: Excel: Conditional Formatting for Beginners
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Format based on formulas
From the course: Excel: Conditional Formatting for Beginners
Format based on formulas
- [Instructor] Although there are quite a few ways of applying Conditional Formatting, one approach to Conditional Formatting that's not so obvious from the various choices that we see under Highlight Cell Rules, Top/Bottom Rules, and those in both cases at the bottom you'll see More Rules. And one of the options could be use a formula to determine which cells to format. Now, by way of an example, on this worksheet called Formula Based Formatting, we've got some quotas in column D and then the resulting sales figures in column E. What we'd like to bring out is that for those persons whose sales numbers exceeded the quota, in order words we want to be comparing these two entries one by one in each of these, we'd like to do this by way of Conditional Formatting but no obvious way. But the way we do it is after selecting column E, go to Conditional Formatting, and we can either go to the bottom here and choose More Rules, or…
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.