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.
Hi,
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.
Thanks,
Chris
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.
