Change Font color (Conditional formatting)
Hello, I have a percentage variance that appears as a formula derived from 2 other fields. I would love to see a number change color when it's higher than 100% or less than 100% in a given situa...
Forum Discussion
The usual approach - I think! - would be to create a formula rich text field that wraps some formatting around the percentage value. This is a very basic example that changes the background colour to either red or green - in practice you'd want to adjust the styling to suit your needs:
If([Development Status Number]>1,"<span style='background-color:red;>" & [Development Status Number] & "</span>","<span style='background-color:green;>" & [Development Status Number] & "</span>")
In cases where you want to add formatting to a field that is entered on a form you can then add both fields to the form and adjust so that the formatted field is shown and the input field is hidden when in display mode and the formatted field hidden when in add or edit mode.
In your case, the field you are adding formatting to is already a formula field, so you would probably just replace the existing field with the new field.
------------------------------
Jeremy Anson
------------------------------
If([Development Status Number]>1,"<span style='background-color:red;>" & [Development Status Number] & "</span>","<span style='background-color:green;>" & [Development Status Number] & "</span>")
In cases where you want to add formatting to a field that is entered on a form you can then add both fields to the form and adjust so that the formatted field is shown and the input field is hidden when in display mode and the formatted field hidden when in add or edit mode.
In your case, the field you are adding formatting to is already a formula field, so you would probably just replace the existing field with the new field.
------------------------------
Jeremy Anson
------------------------------
Hello!
Thank you for your quick response, I believe I'm misinterpreting something, or I'm unable to do this due to the previous formula I have?
I attached 2 screenshots, and posted the formula I input.
1 screenshot has what's input and the 2nd with the error message.
The error message mentions additional characters beyond the end of the formula, however I've confirmed there are no blank spaces.
Thank you for your help.
If([Design Variance]>1,"<span style='background-color:red;>"If([Design Variance] & "</span>","<span style='background-color:green;>" & [Design Variance] & "</span>")
------------------------------
Anthony Wong
------------------------------
