Color has its place in Microsoft Office documents. From highlighting specific sections of text to including full color examples in charts and tables, it’s something that can never be used too often. Even if you want to match colors from a logo in a document you create in MS Word, you’re covered.

Consider this your guide to applying color to your reports, presentations, and even emails. Once you’ve learned how to use the different tools that are available as a MS Office user, you’ll never be the same. Your personal, professional, and academic communications improve tenfold from the strategic use of color.

Using Custom Colors to Create Brand Cohesiveness

If you want the colors used in your documents and presentations to match those in your logo, you’re going to need to take time to stylize them this way. Your logo likely has a CMYK, RGB or HEX code for you to refer to. Make sure you write each one down for future reference.

To add these colors to your document, you’ll be following a five step process. It’s really easy to follow so don’t worry. In a matter of no time, your document or presentation will reflect the colors of your brand.

The first thing you need to do is highlight the words that you want to recolor. Next, choose the icon that looks like an “A” on the Home Tab. This is the Font Color tool which allows you to choose “More Colors”.

Once the Colors bars comes up, choose the slider option then CMYK on the drop down menu (or whatever color format you’ve chosen to use). You’ll then type the CMYK color code and hit OK. Check to make sure that the colored text matches the colors in your logo.

Repeat the steps as many times as it is necessary. You can also save a template that you can use over and over again. Just make sure you choose Word Template for the format when you’re saving the document.

How to Highlight Cells in Excel and Make Them Another Color

The conditional formatting feature in Excel is one that you’ll find useful especially if you’re using older versions of MS Word. In order to add emphasis to an area of text, you’ll need to create a table containing data that you want to share with others. To do this, follow the following steps.

Once you’ve determined how to format the table using the number of rows and cells that you need, you’re going to use Excel’s formatting tools to determine which parts of the data will be affected by conditional formatting and which won’t. You do this by setting a border and formatting the header line.

To set the conditional formatting rules, choose the first cell in the row you want formatted. Then click on Conditional Formatting under Styles under the “Home” tab. You’ll then want to select Manage Rules from the dropdown menu.

When the Conditional Formatting Rules Manager dialog box opens up, you’ll want to click on New Rule. You have to then choose the last option give which is “Use a formula to determine which cells to format.” The formula must evaluate to True and be able to be used across the entire table later when you need it to.

Click Format and New Formatting Rule. Then when the Format Cells dialog box opens, change the fill to a different color by clicking on the Fill tab.

Click OK when the Format Cells dialog box is open. You’ll then be able to preview the cell. When you’re done doing that, click Ok and return to Conditional Formatting Rules Manager and click Apply. If the cell changes, your formula was correct.

With a working formula in place, you’ll want to apply it across the table. Click the button that reads Applies to and drag the selection across the table with the exception of the headings. Click the button beside the address field to get back to the Conditional Formatting Rules Manager.

Press Enter and then Apply after seeing the selected area and Applies to. Every row should be formatted according to the rule you set it up for. It’s that easy and useful, too!

SoftwareDepot Gives You an Advantage Personally, Professionally, & Academically

Download Microsoft Office from SoftwareDepot today and make a difference in how you’re seen as a person, business professional or student. You’ll have tools and features available at your fingertips to use and enjoy throughout the years. It doesn’t matter if you download Office 2016 Student or Office Professional Plus 2016.

You still get the SoftwareDepot advantage. Within minutes of buying your software, you’ll be given instructions on how to download it and start using its many programs right away. Enhance the quality of your documents right away by learning how to apply color to the fonts you choose and the visual presentations that you create.