Conditionally Format Multiple Selections?
I have a column that allows for multiple check boxes. Is there a way to make conditional formatting prioritize a selection?
For example: If I have low, medium, high as options I can make it color code green, yellow, red.
But if I have low - me, low - you. low - them, medium - me, medium - you, medium - them, high - me, high - you, high - them
Is there a way that selecting any combination would result in the color coding of the highest priority? If I select low, you select medium, and they select high - then I'd want it to be red for high.
If two people select medium, and one low - then I'd want it to be yellow for medium
I haven't found a way in which to make this work and it might be too complicated.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!