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.