The World’s Largest Online Community for Developers

'; google sheets - How to conditionally format a SUBSET of text in a cell - LavOzs.Com

Want to color specific text within a cell of Google Sheets, for example:

The {Login Page} shall contain a [Login Button]

I want {Login Page} to be red while [Login Button] is orange.

Would like to achieve this using conditional formatting (unless you can convince me that Google Sheets' scripts are simple and easy to learn).

Is this possible with conditional formatting?

If you are after this then it's NOT possible:




You can do this only manually. There is no way to pull this off automatically in Google Sheets with formulas, conditional rules nor even with a script. Multicolor text is not supported to be achieved other than setting it up manually on non-formula output.

Also transferring (see image 1) multiple individual colors from in-one-cell to another cell is not possible at this current version of the Google Sheets (nor at any previous versions).

The next and last thing you can do is overlay it with a Drawing or Image like:

String formatting: % vs. .format
How can I print literal curly-brace characters in python string and also use .format on it?
Conditionally Formatting Spreadsheet Cells
Conditional formatting based on another cell's value
Google App Script - Conditional Formatting Based on Another Cell
Conditionally format Google Sheets cell based on text in a different cell
Toggle conditional formatting based on cell value
Google Sheets condition formatting: format blank cells that are in even rows
Google Sheets trying to add text to a cell with conditional formatting
How to compare a column with a cell id instead of value using google sheets conditional formatting option?