Dropdown Conditional Formatting Issue

[jesenavaranjan]

hi - so I have a dropdown, and under the color property, I am using a conditional formatting (If(value=1, red ) etc..

But the issue is, as attached in the picture, the colour also shows on the dropdown

What Can I do to either show all the correct dropdowns or to show the dropdown values as Black untill something is selected?

Please and thank you.

[v-yuxima-msft]

Hi @jesenavaranjan ,

Do you want to the values are black and after they are selected, it is red?

I think you can set color:Black, selection color: Red of the dropdown’s property.

Result:

Hope this can be helpful.

Best Regards.

Yumia

[jesenavaranjan]

If(MQ1.Selected.Value="1",Blue,If(MQ1.Selected.Value="2",DarkGreen,If(MQ1.Selected.Value="3",LightGreen,If(MQ1.Selected.Value="4",Orange,If(MQ1.Selected.Value="5",Brown,If(MQ1.Selected.Value="6",Red,If(MQ1.Selected.Value="7",Magenta,Black)))))))

That is my formula, So I need various colours...