Question

Fill the column in red and green so that the values above a certain number are highlighted in gradient of red and the ones below the number are highlighted in a gradient of green Mention how you can do that or why it cannot be done

Answer 1

Answer:

Explanation:

Yes ,it is possible.

we just need to select the column (ctrl+ shift +down key) in the conditional formatting we can find colour scale and then again from conditional formation option select manage rules and from 2-color scale it can be achieved by putting number number in lowest and highest values accordingly