AnthonyWong1

3 years agoQrew Member

# 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

------------------------------

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

------------------------------