For this example, the key is to assign a value for each background color, and use that value as the criteria for our SUMIF function.
However, it cannot be entered directly as a worksheet function.
Below figure shows column D that is filled with the corresponding color number for the background color in column C.
We want to sum the orders in C3:C8 that satisfy the given criteria.
If you want to save hours of research and frustration, try our live Excelchat service Our Excel Experts are available 247 to answer any Excel question you may have.
We guarantee a connection within 30 seconds and a customized solution within 20 minutes.
To change the text color used by a reviewer for markup, see Add and print comments in Numbers on Mac.
Change the color of text or add a gradient Select the text you want to change.
To change all of the text in a text box or table cell, select the text box or table cell.
In the Format sidebar, click the Text tab, then click the Style button near the top of the sidebar.
Choose one of the following: A color that coordinates with your template: Click the pop-up menu below the Font section, then choose Text Color.
Any color: Click the pop-up menu below the Font section, then choose Text Color.
Click the color wheel, then choose a color from one of the color palettes.
A two-color gradient fill: Click the pop-up menu below the Font section and choose Gradient Fill.
Choose two colors.
The color well shows colors that match the template; the color wheel opens the Colors window, where you can choose any color.
A custom gradient: Click the pop-up menu below the Font section and choose Advanced Gradient Fill.
Click near the bottom edge of the slider to add another color stop.
Best window managers for macYou can drag the color stops and use the other controls to change the blend, angle, and direction of the gradient.
To apply the gradient based on the length of the shape or text box (not the size of the selected text), select the checkbox next to Apply gradient to entire object.
The gradient changes when the size of the object or text box changes.
Click the pop-up menu below the Font section and choose Image fill, or choose Advanced Image Fill if you want to add a tint to the image.
Click Choose, navigate to your photos, then double-click an image with a.jpg,.png, or.gif filename extension.
If you chose Advanced Image Fill, click the color well (to the right of the Choose button) and select a tint color.
![how to choose fill color for background excel mac how to choose fill color for background excel mac](/uploads/1/3/4/6/134662719/189420471_orig.png)
If the image doesnt look the way you expected or you want to change how the image fills the text, click the pop-up menu above the Choose button, then choose an option: Original Size: Places the image inside the text without altering its original dimensions.
How to get time screensaver for macStretch: Resizes the image to fit the texts dimensions, which might change the images proportions.
Scale to Fill: Makes the image larger or smaller to leave no space in the text.
![how to choose fill color for background excel mac how to choose fill color for background excel mac](/uploads/1/3/4/6/134662719/431273320_orig.png)