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.
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
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...
User | Count |
---|---|
200 | |
102 | |
89 | |
45 | |
43 |
User | Count |
---|---|
247 | |
106 | |
103 | |
65 | |
60 |