How to Add HTML Formatting to Non-Text Formulas

Does anyone know how you can add HTML formatting to a formula field in a search if the formula type is not text (e.g. Currency Formula)?

I want to color values red that are below 0. I know I can add HTML tags to do this when it’s a text formula, but I’m not sure how to format number values.

Beginner Asked on April 24, 2021 in Saved Searches.
Add Comment
1 Answer(s)


You’ll need it to be text to apply the formatting but you should be able to display the number inside the HTML as text.

The only issue you might have is sorting, etc.



Intermediate Answered on April 24, 2021.

Do I need to convert the number to text inside the formula? I think if I return a number to a formula (text) field it’ll produce an error if I remember correctly.

on April 24, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor