Forum Discussion
Solved
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.
The ASAPCELLCOLORINDEX function returns the fill color index of a cell. You can use this in an IFS or SWITCH formula.
HansVogelaar That's perfect and does exactly what I needed. Thank you so much!
