Office 2016 – myitlab:grader – Instructions Excel Project Step Instructions Points Possible 10 Format the range C6:F8 with Accounting Number Format. 6.000 11 Format the range G6:G8 in Percent Style with one decimal place. 6.000 12 Apply Blue, Accent 1, Lighter 80% fill color to the range E5:G8. 4.000 13 Select the range C5:D8 and apply a custom fill color with Red 242, Green 220, and Blue 219. Click Home the arrow next to Fill Color, or press Alt+H, H. Under Theme Colors or Standard Colors, pick the color you want. To use a custom color, click More Colors, and then in the Colors dialog box select the color you want. Tip: To apply the most recently selected color, you can just click Fill Color. Select (highlight) the text you wish to change and right click the text box. Open the 'Font Color' drop window and choose.' Choose a Base color and left click the Tint/Shade frames to adjust Tint.Volunteer J - MS-MVP. The conditional fill tip posted by mothergreen I think is a good start, but only works for the row label parts of the pivot, and anything that goes in as a value remains an issue (where the fill color is deleted once the pivot table expands and then contracts).
This Excel tutorial explains how to change the background color of a cell in Excel 2016 (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Question: How do I change the background color of a cell in Microsoft Excel 2016?
Answer: By default when you create a new workbook in Excel 2016, all cells will be formatted with a background color that is transparent. This allows you to see the grid lines in the worksheet. You can change the background color of any cell to enhance the look of your document.
TIP: When you change the background color, you will no longer see the grid lines around the cell. So you may want to add a border to the cell.
To change the background color of a cell, select the cell that you wish to change the color of.
Right-click and then select 'Format Cells' from the popup menu.
When the Format Cells window appears, select the Fill tab. Next choose the color that you wish to use as the background color or you can choose 'No color' to return the cell back to its default transparency.
In this example, we've selected green as the background color.
Now when you return to your spreadsheet, the cells that you've selected should have a background color, as follows:
How to fill a shape with transparent background color in Excel?
Normally, the shape we inserted into worksheet was filled with no transparency background color. If you want to fill a certain shape with transparent background color, you can try the following method.
Fill a shape with transparent background color in Excel
Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!
Save 50% of your time, and reduce thousands of mouse clicks for you every day!
Please do as follows to fill a shape with transparent background color in Excel.
1. Right click a shape you need to fill with transparent background color, then click Format Shape from the right-clicking menu. See screenshot:
![Lighter Lighter](/uploads/1/1/7/7/117735132/358167815.png)
2. If you are using Microsoft 2016 and 2013, the Format Shape pane will pop up on the right side in current worksheet, please expand the Fill options under the Fill & Linetab, keep the Solid fill option selected, specify a background color in the Color drop-down list as you need, then enter a transparent percentage into the Transparency box. And finally close the Format Shape pane. See screenshot:
And if you are using Microsoft 2010 and 2007, a Format Shape dialog box will pop up as below screenshot shown. Please select Fill in the left bar. In the right side of the dialog box, keep the Solid fill option selected, specify a background color in the Color drop-down list as you need, then enter a transparent percentage into the Transparency box. And finally close the dialog box.
Excel Change Fill Color Formula
You can see the specified shape is filled with transparent background color as below screenshot shown.
Related articles:
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
or post as a guest, but your post won't be published automatically.
Lighter 80 Fill Color Excel Formula
Loading comment... The comment will be refreshed after 00:00.
Lighter 80 Fill Color Excel Shortcut
- To post as a guest, your comment is unpublished.Would you please list applicable product versions on software articles? E.g., Excel 2003,2007,2010
- To post as a guest, your comment is unpublished.Dear Anon,
Thank you for your comment. Your suggestion will be taking into consideration. And the article is now updated.
- To post as a guest, your comment is unpublished.How about putting a date at the top of your webpages so I can assess its applicability. Just because other dumbass sites do an inept job of showing article dates, doesn't mean that you should to. Be worth a darn instead of being a lame get-by-with-the-minimum-effort slacker.
By the way, on IE11 this page refuses to scroll from the mouse scroll wheel. It makes the page frustrating to navigate.