Hi Bhargavi,
Here is a rich text formula you can use!
If(ToText([Workstream]) = "", "",
"<span style='color: #FF0000'>" & "• " & "</span>" & Part(ToText([Workstream]), 1, ";") & "<br>"&
"<span style='color: #FF7F00'>" & "• " & "</span>" & Part(ToText([Workstream]), 2, ";") & "<br>" &
"<span style='color: #FFFF00'>" & "• " & "</span>" & Part(ToText([Workstream]), 3, ";") & "<br>" &
"<span style='color: #00FF00'>" & "• " & "</span>" & Part(ToText([Workstream]), 4, ";") & "<br>" &
"<span style='color: #0000FF'>" & "• " & "</span>" & Part(ToText([Workstream]), 5, ";") & "<br>" &
"<span style='color: #4B0082'>" & "• " & "</span>" & Part(ToText([Workstream]), 6, ";") & "<br>" &
"<span style='color: #9400D3'>" & "• " & "</span>" & Part(ToText([Workstream]), 7, ";") & "<br>" &
"<span style='color: #964b00'>" & "• " & "</span>" & Part(ToText([Workstream]), 8, ";") & "<br>" &
"<span style='color: #008080'>" & "• " & "</span>" & Part(ToText([Workstream]), 9, ";") & "<br>" &
"<span style='color: #FFC0CB'>" & "• " & "</span>" & Part(ToText([Workstream]), 10, ";"))
The only changes you should need to make are the colors of your bullets by changing the hex code. This example is for 10 entries in a multi-select, but if you need more simply add more lines in the same format. Your result should look similar to this:
Please let me know if you have any trouble with it!
Thanks a ton Tyler, but it willl give same colors irrespective of the values I believe. Suppose for few records we will be selecting only 4 values instead of 10. Here what I exactly want to display is if the value is "A" then red bullet, "B" green...etc. There can be multiple values, No matter on their position color should be same. Hope you got my point. Also, I don't want extra bullets to be created unnecessarily. like below.
------------------------------
Bhargavi Katepalli
------------------------------
