The AblebitsMinByColor function returns the smallest value in cells with the specified in the argument background color.
=AblebitsMinByColor(C3:I9,N22) Returns the smallest value in a range of cells C3:I9 that have the same background color as the N22 cell.
=AblebitsMinByColor(C3:I9,255) Returns the smallest value in a range of cells C3:I9 that have the background color of 255 color code.
Note. Formulas created with this function will work only on machines with installed Ultimate Suite for Excel. If the workbook is opened on another computer where Ultimate Suite is not installed, the result will be lost.
The AblebitsMinByColor function syntax has the following arguments:
Required. The range of cells where you want to find the smallest value, e.g. B2:B8.
Required. The background color of cells to search for the smallest value. Can be a reference to one cell like B6 or color code like 255.
Note. If the first argument contains no numbers, AblebitsMinByColor returns 0 (zero).
The AblebitsMinByColor function is used by the Count and Sum by Color add-in when you check the Insert result as formula box before pasting the result.
If you want to get the color code of the background color of a cell, you can use the AblebitsGetCellColor function.
Multiple ranges are not supported.
The function does not work for conditionally formatted cells and for ranges formatted as tables with colored alternate rows or columns.