AnsweredAssumed Answered

Conditional Formatting within value range

Question asked by user2148443 on Feb 9, 2019
Latest reply on Feb 9, 2019 by comment

I am wanting to set up conditional formatting to highlight values from some fields within a certain range of a median value.


So, for example:-

I have a Value of 4,6,8,10,12,14,16. with a median value of 10

What i want to do is highlight values within 2 of the median value in green and those >2 above with Yellow and those >2 below with Red.


Is there a way to do this, as trying to set up a hot zone map for an irrigation system showing the distribution of water from the sprinklers.

Sorry Forgot to mention this is for a button. The value is in a field within the button.