From the course: Excel 2016: Advanced Formatting Techniques
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Use fill color and patterns for cell backgrounds
From the course: Excel 2016: Advanced Formatting Techniques
Use fill color and patterns for cell backgrounds
- In this worksheet called FillColor we're seeing various examples of using color backgrounds and also color effects. We've got some yellow backgrounds right here. The title up top is a green background with yellow font on top of it. Down at rows 9, 10, and 11 here, we've got sort of a tan background but also with dots. You can see some dots down here as well, too. And probably overkill, but we see some mixed colors over here. All these from time to time might be appropriate. So, let's start with this idea here. These cells have been highlighted and made yellow because they're not formulas. But everything else in this worksheet, all the numerical information, happens to be formulas. So we're offsetting those just a little bit differently. East to apply, easy to remove. We've decided maybe we don't want these anymore. Usually as we apply these features it's the Fill Color bucket located in the Font group on the Home tab. Click the drop arrow, lots of choices. These colors will be…
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.