Is it possible to add individual colors to concatenated text from other columns

Question

Hello,

Basically, in my calculated column I have a concatenate function bringing first and last name together.

=CONCATENATE([FirstName]," ",[LastName])

But I have a request to have each column referenced a different color like so

Is this possible, How can I accomplish this?

Thank you for any help,

DK

Answer 1

Hi @Derek Kent,

Thank you for posting in this community.

Unfortunately, there is no way to change the color of the text by the calculated formula alone. Calculated formulas are mainly used to calculate column values but are not responsible for the style of column values.

We can use JSON formatting to change the style of column values. Rest assured, it only changes the display style of the column values, not the column values.

1.Select your calculated column > format this column.

2.Select Advanced mode.

3.Copy the following JSON Code.

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "children": [
    {
      "elmType": "span",
      "txtContent": "[$FirstName]",
      "style": {
        "color": "#ff0000"
      }
    },
    {
      "elmType": "span",
      "txtContent": "[$LastName]",
      "style": {
        "padding-left": "4px",
        "color": "#00ff00"
      }
    }
  ]
}

Here is my test result:

---

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.