Can someone help me with a work around for this conditional formatting roadblock?
When using Conditional Formatting, I want to make my primary column change colors when a combination of choices are made in a multi-select dropdown.
I have it set up to apply this format when the condition is not met: If column 2 is 'condition' and column 3 contains 'condition one' OR 'condition two' then apply this format to column one
Is there a way to change it to column 3 contains 'condition one' AND 'condition two'?
Multiple conditional formatting rules do not work since the higher rules take priority which blocks the functionality I am looking for. Additionally and unfortunately the "define custom criteria" workaround does not work for this situation as there isn't an option for "Does not contain" and only an option for "contains"
Am I missing something to make this work, or can someone help me with a workaround for this conditional formatting roadblock? Is there another option I can use?