SharePoint List conditional formatting MultiChoice field

Question

I have a question I hope someone has the solution. I created a SharePoint list with a multi-choice field called "Equipo" that can take several values at the same time. I have tried the following:

"background-color": "=if([$Equipo]=='FA','#FFF3D6',if([$Equipo]=='GC','#DEF7EB','#E7E7EE'))"

It worked when "Equipo" was a Choice field. However, I needed this field to be multi-choice, and now it is not working. I would like that if Equipo has one option, card looks with a particular color. Otherwise (several options selected), in white.

Where is the issue?

Thanks in advance

Answer 1

Hi @Fernando Juan Jarque

I'm glad to hear you solve the problem and thanks for your sharing!

By the way, since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others.". So, I would make a brief summary of this thread.

You could click the "Accept Answer" button for this summary to close this thread, and this can make it easier for other community members to see the useful information when reading this thread. Thanks for your understanding!

[SharePoint List conditional formatting MultiChoice field]

Issue Symptom:

OP created a SharePoint list with a multi-choice field called "Equipo" that can take several values at the same time. OP have tried the following:

"background-color": "=if([$Equipo]=='FA','#FFF3D6',if([$Equipo]=='GC','#DEF7EB','#E7E7EE'))"

It worked when "Equipo" was a Choice field. However, OP needed this field to be multi-choice, and now it is not working. OP would like that if Equipo has one option, card looks with a particular color. Otherwise (several options selected), in white.

Current status:

OP found the solution.

"background-color": "=if(length([$Equipo])>1,'#EFF1F4',if(indexOf(join([$Equipo],''),'Team1') != -1,'#EFFBF0',if(indexOf(join([$Equipo],''),'Team2') != -1,'#EEF5FC',if(indexOf(join([$Equipo],''),'Team3') != -1,'#F2EFF7',if(indexOf(join([$Equipo],''),'Team4') != -1,'#FEEEEC',if(indexOf(join([$Equipo],''),'Team5') != -1,'#FFF9EB',if(indexOf(join([$Equipo],''),'Team6') != -1,'#F0FAF9',if(indexOf(join([$Equipo],''),'Team6') != -1,'#F5F5F5','#EFF1F4'))))))))"

Answer 2

Whether you want to set background color for each choice value or entire choice column?

1.For each choice value, click the column -> Column settings -> Format this column -> Edit styles -> Choose color.

2.For entire choice column, currently, JSON formatting does not support setting background color for multi-choice column.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.