From the course: Excel 2016: Advanced Formatting Techniques

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Use styles and themes for consistent formatting

Use styles and themes for consistent formatting

From the course: Excel 2016: Advanced Formatting Techniques

Start my 1-month free trial

Use styles and themes for consistent formatting

- Excel has a formatting capability referred to as Styles and also one called Themes. We are looking at a worksheet called cell styles. And maybe we just these numbers here, January through December, not the total, and ignore the totals right side down at the bottom. We want these cells to stand out a little bit differently. So, on the home tab in the ribbon, I've got a choice called Cell Styles, and lots of choices. And as we slide over these, we see different color backgrounds, and by the way, notice here, all you see the word Bad and Good, and Neutral. Of coarse, the data is standing on it's own for whatever it might mean. You can ignore the real meaning of the words good and bad as you choose some of these colors. But as you look at these colors, one thing you probably recognize is that we are not seeing for example, a canary yellow, or a bright red, or a shar-truce here. This is a limited pallet. I don't see any purples in here. And the general idea is, if you're using different…

Contents