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
------------------------------
