In this article we will show you how to add change the colour of a part of your text - either for the full cell text or a part of it.

You will need open the Settings, click on the Data tab, then scroll down to and click on "Col. Special Formatting".

Next, select the column where you want to change the text color. In our example, it will be for column C. Then select Sp. text.

In the spreadsheet, you will need wrap the text that you want coloured between :colorCode:text::. See the following example:

Your :#ff0000:red text:: and your :#00cc00:green text::

The above text will render the following result

Of course, you can have any text colour. Use this color picker to find the code for your desired color.