Skip to main content
Question

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 situation, and in green when it's the opposite.

Is this something that I place in the formula beneath it? I've been searching where I change and edit aspects of the field, but all I see is display it in Bold.

Thank you very much for your support!

------------------------------
Anthony Wong
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+7
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
------------------------------
Terms & ConditionsAccessibility statement