Formula Rich Text Field Color

Question

I have a Formula Rich Text Field that's pretty simple: [Season]&" "&[Guarantee Type]&": "&[Guarantee Description].
How do I make the "Season" field the color Red?

------------------------------
Mike McCartney
------------------------------

markshnier__you · Answer

Try this"&lt;font color=red&gt;" &amp; [Season] &amp; "&lt;/font color&gt;"&nbsp;&amp;" "&amp;[Guarantee Type]&amp;": "&amp;[Guarantee Description]------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

mikemccartney · Answer

Thanks Mark.&nbsp; Copied what you gave me and got this:&nbsp;&lt;font color=red&gt;2020&lt;/font color&gt; Full GuaranteeIs the formula missing something?&nbsp; Also, I have a few child records it's accessing.&nbsp; Can I get it to "return" for a new line for each child record?------------------------------Mike McCartney------------------------------

markshnier__you · Answer

Is the field type formula text or formula rich text. It needs to be the latter.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------

mikemccartney · Answer

It's a Formula Rich Text field that's combining some fields from child table (Season is a text field. Guarantee Type is a text multiple choice and Guarantee Description is a text field).&nbsp;&nbsp;Rather than making the Season a color, I now simply want to force it on a new line.&nbsp; For example, I have 3 Seasons, 2020, 2021 and 2022.&nbsp; Right now, it shows up with something like this:&nbsp; 2020 Guaranteed for 6 months. 2021 Guaranteed for 4 months. 2022 Not Guaranteed. Instead how do I make it:2020 Guaranteed for 6 months. 2021 Guaranteed for 4 months. 2022 Not Guaranteed.&nbsp;Here's the Formula Rich Text field:&nbsp;&nbsp;[Season]&amp;" "&amp;[Guarantee Type]&amp;": "&amp;[Guarantee Description]------------------------------Mike McCartney------------------------------

paulpeterson1 · Answer

Try this
&nbsp;[Season]&amp;"&lt;br&gt; "&amp;[Guarantee Type]&amp;": "&amp;[Guarantee Description]------------------------------Paul Peterson------------------------------

Forum Discussion

Formula Rich Text Field Color

5 Replies

Related Content

Color Code Date Field based on Formula

QrewTip: Formula Logic Order

Color Coding based on field value

Color coding formula

Date Field Formula