Color Function In Excel at Color

Color Function In Excel. In the new formatting rule dialog, select the option use a formula to determine which cells to format . Now select use a formula to determine which cells to format option, and in the box type the formula:

SUMIF(S) Based on Cell Color
SUMIF(S) Based on Cell Color from www.teachexcel.com

In excel, there is no function to make calculations based on the color of the cells. Step 2 in cell o1 paste formula: Then select format button to select green as the fill color.

SUMIF(S) Based on Cell Color

Instead of a formula based on the color of a cell, it is better to write a function that can detect the color of the cell and manipulate the data accordingly. On the home tab, in the styles subgroup, click on conditional formatting→new rule. Step 3 in cell p1 paste formula: Sum by color from the subtotal function is the easiest way to get the sum result by color in excel.