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.
Forum Discussion
Is there a function in ASAP Utilities that will enable me to return a value based upon the colour of another cell? I can't find such function.
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!