Forum Discussion
Return a value based upon a cell colour
I need to assign three different values based upon three different cell colours
The ASAPCELLCOLORINDEX function returns the fill color index of a cell. You can use this in an IFS or SWITCH formula.
Thank you a lot, but the condition of the format is dynamic, which sums different range based on the cell index..😔
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.
- Thank you a lot! I will try it!!
