How to easily sum values by a cell’s background color in Excel Your email ... but let’s use a built-in conditional formatting set for this example using a basic data set: Select B2:B18 ...