Forum Discussion
paul-cas1962
Aug 25, 2021Copper Contributor
Return a value based upon a cell colour
I need to assign three different values based upon three different cell colours
- Aug 25, 2021
The ASAPCELLCOLORINDEX function returns the fill color index of a cell. You can use this in an IFS or SWITCH formula.
HansVogelaar
MVP
You need custom functions for that.
You can either copy them from Color Functions In Excel or use ASAP Utillities (free for personal use)
paul-cas1962
Aug 25, 2021Copper Contributor
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.
- HansVogelaarAug 25, 2021MVP
The ASAPCELLCOLORINDEX function returns the fill color index of a cell. You can use this in an IFS or SWITCH formula.
- paul-cas1962Aug 26, 2021Copper Contributor
HansVogelaar That's perfect and does exactly what I needed. Thank you so much!