Forum Discussion
Return a value based upon a cell colour
The ASAPCELLCOLORINDEX function returns the fill color index of a cell. You can use this in an IFS or SWITCH formula.
The problem is that the actual formatting applied by conditional formatting is not available in a cell formula.
Instead of referring to the color, you'll have to use the conditions behind the conditional formatting rules. For example, if a cell is colored red if its value is greater than 100, your formula would have to search for values greater than 100.
That will make it complicated. I cannot offer a suggestion without seeing (a copy of) the workbook...
Hi HansVogelaar, below is my conditional format details, to sum the cells value before current cell and check if more than the cell value in I column of this row...maybe some suggestions?
See the attached demo workbook. You'll have to allow macros.