ContributionsMost RecentMost LikesSolutionsHow do I show negative numbers on a chart?Is there a way to change the value range on the Y-axis of a chart? If there is a negative number, it doesn't show, since the Y-axis starts at 0. See screenshot. Thanks Re: Conditionally change color of formula numeric field, either text or background, without using a a Formula Text field.And returning 34.0, not this mess: 34 34 . 340Re: Conditionally change color of formula numeric field, either text or background, without using a a Formula Text field.I need = to be black, over to be red, and under to be green. I don't understand why it's returning multiple values....Re: Conditionally change color of formula numeric field, either text or background, without using a a Formula Text field.I still get something like this: 34 34 .0Re: Conditionally change color of formula numeric field, either text or background, without using a a Formula Text field.When I add this: &"<div style=\"background-color:red;\">"& [Remaining Hours Original] I get this: 6. 6 0 Vertical in the field, like that.Re: Conditionally change color of formula numeric field, either text or background, without using a a Formula Text field.OK, I got this to work from an earlier post from Mark. If([Remaining Hours Original] >0, ToText(Int([Remaining Hours Original])) & "." & If(Int([Remaining Hours Original])=[Remaining Hours Original],"0", Length(Right(ToText([Remaining Hours Original]),"."))=1,Right(ToText(Frac([Remaining Hours Original])),1) & "0", Right(ToText(Frac([Remaining Hours Original])),"."))) I also want to conditionally change the color. How do I add that? thanksRe: Conditionally change color of formula numeric field, either text or background, without using a a Formula Text field.Right, but can I multiply by 100 in the formula text field? If I multiply by 100 in the formula numeric field it obviously screws that up.Re: Conditionally change color of formula numeric field, either text or background, without using a a Formula Text field.If I'm converting numeric to text such as 6.0, what do I add to the formula to keep that decimal place? Right now it converts on to 6.Re: Conditionally change color of formula numeric field, either text or background, without using a a Formula Text field.I am trying to do this with percents, remaining hours, and budget. Yes, sometimes there is a truncation issue. Sometimes I get a "1.03" instead of a "103" in the formula text field. If I add 100 to the source field, it messes up the original calculation.Re: Conditionally change color of formula numeric field, either text or background, without using a a Formula Text field.Thanks Blake. What would the formula be to conditionally change a related formula field? For example, if the project is over budget, have a [Budget Status] field change red.