Formula Field Coloring Help
Hey, guys, I have an issue trying to color the font and change the font size in a formula text field (which I made to be able to use HTML for a formula numeric field). The issue is that the number ...
Forum Discussion
Try this:
"<div style=\"font-size: 9pt; color:black;background-color:orange; width:80px; text-align:center; \">"&"YOUR TEXT VALUE HERE"&"</div>",
"<div style=\"font-size: 9pt; color:black;background-color:orange; width:80px; text-align:center; \">"&"YOUR TEXT VALUE HERE"&"</div>",
- That is kind of where I was going with it, but the text happens to be that last line of the formula;
"$" & List(",",$Thousands,$Hundreds) & $Decimals)
because it is pulling a number from the [Calculated SL Tax] field (listed above as variable 'Value') But I had to use the rest of the formula to keep the currency formatting. So basically, what do I wrap the div style with? Where do I place it so it returns the coloring? I have zero idea, and if anyone has any other way of colorizing a formula number field AND maintain formatting, im all ears - you could potentially create the formula in one field and then the formula text field to colorize the result in a separate field. thoughts?
- If I follow you, you're saying to create a third field that would pull from this field and wrap that in the div style to get the coloration? If so, I think that might just work.
- yea, thats what I am thinking. It might be the fastest way to your solution.
- the formula would look like this though:
"<div style=\"font-size: 9pt; color:black;background-color:orange; width:80px; text-align:center; \">"&[YOUR FORMULA FIELD HERE]&"</div>", - Eric, you are a genius my friend, thank you! It's perfect
- you're welcome! any time.
